Find out why Prudential plc, an international financial services group responsible for £505 billion in assets, relies on SQL Monitor to check historical issues, catch performance problems, and monitor the activity of over 100 SQL Servers.
When digital marketing and customer relationship management agency Digital Outsource Services switched to SQL Monitor to monitor 24 production servers, they saved 15 hours a week. Theresa Boonzaaier, Senior DBA, tells you how in this case study.
Business communications software company Interactive Intelligence have tracked their SQL Servers with SQL Monitor since 2011. Now their IT team is alerted to SQL Server problems before they impact customers. See how they do it in this case study.
Geekswithblogs.net use SQL Monitor to keep their servers running smoothly for their users around the world.
They use SQL Monitor to help look after server performance, determine why certain issues occur, and get daily statistics on blogger registration and content production.
Find out how Monsoon Commerce use SQL Monitor to track the databases that power alibris.com, an online marketplace of more than 150 million items.
See how to get up and running with SQL Monitor in 5 minutes and start monitoring your SQL Servers. This step-by-step guide shows you in real-time how simple and quick the installation process is.
Getting SQL Server monitoring in place is great, but to really make it pay off, you need to take the time and trouble to customize your alerts. Find out why you should do this and how to get the job done with SQL Monitor.
Grant Fritchey shows you how to easily monitor your AlwaysOn Availability Groups using Redgate’s SQL Monitor. See instantly how your replicas are performing and if, in the result of a failover, your Availability Groups are in the correct state to keep your service running.
SQL Monitor’s Anne Edwards covers how to set up pre-written custom metrics for SQL Server from sqlmonitormetrics.red-gate.com in SQL Monitor.
Grant Fritchey tells you how deadlocks can be captured and understood using SQL Monitor.
Let's say a user reports that the performance on their application seemed slower than normal that morning. Was it? And if so, what changed? These are hard questions to answer, unless you have baselines to compare against.
Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers.
Tony Davis and Grant Fritchey provide an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor.
"Managing SQL Server Availability Groups is a bit like spinning plates. But with a good monitoring tool you can see at a glance the status of an Availability Group as a whole, and then go deeper into each replica and database.
"Suddenly, you no longer need to spin plates."
The SQL Monitor Reporting Services Pack is a series of SSRS reports for servers and databases monitored by SQL Monitor. It provides handy examples of the types of reports you can generate from SQL Monitor's data repository.
The pack is available as a free download and includes these reports:
Details of how to install and use the pack are included in the download.Download SSRS pack
NOTE: this pack includes a set of example reports, to show how SSRS reporting can work with SQL Monitor. It is not part of the core product and, consequently, is not supported.
If you want SQL Monitor to collect extra performance data that's particularly important for your servers, you can now add T-SQL scripts to do it.
You can analyze this data and receive alerts about it just like any other data that SQL Monitor collects.
On our dedicated custom metrics site, SQLMonitorMetrics.com, you can find and review T-SQL scripts and import them directly into your copy of SQL Monitor.
MVPs, the SQL Monitor team, MVPs, and the SQL Server community have added scripts to the site. You can access it straight from SQL Monitor.
If you run applications that store data in SQL Server, you can use custom metrics to monitor and alert on the data they collect, so you can now use SQL Monitor to track business activity, too.