When UK-based retailer and manufacturer Mama & Papas found that their in-house SQL Server monitoring system wasn’t up to the job, and was also creating more work for them, they turned to SQL Monitor and dramatically changed the way they work.
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.
In this session Grant Fritchey describes how SQL Monitor can make diagnosing SQL Server problems quicker and easier.
SQL Server Monitoring Specialist James King takes you from getting a simple overview of your entire SQL Server estate to alerting and diagnosis of SQL Server problems.
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.
SQL Monitor’s Anne Edwards explains how to check baselines for SQL Server performance metrics in Redgate 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.
SQL Monitor’s Anne Edwards shows you how to set up a new custom SQL Server metric in SQL Monitor. She covers entering T-SQL code, choosing SQL Server instances to monitor, data collection frequency, and more.
Why do you need to automatically monitor the SQL Servers in your care? What's the business value? What features should you look for in a performance-monitoring tool? In this free nine-page guide, SQL Server MVP Rodney Landrum gives you the answers.
Working with SQL Server? Here are five signs that a tool could make your job easier, your life simpler, and work less stressful. Read them now.
Locking and blocking is a normal and required activity in SQL Server. However, if we execute long, complex transactions that read lots of data, and take a long time to execute, then locks will be held for extended periods, and blocking can become a problem.
Running out of disk space on a server can cause work to grind to a halt, and be extremely embarrassing for the system administrator. The goal is to avoid this type of issue altogether, via proactive monitoring.
Using any single metric will often lead to an incorrect diagnosis of a problem. By reviewing all relevant performance metrics as a unit, we have the best chance of choosing the most effective course of action.
We need to know not only when jobs fail, but also when they display uncharacteristic behavior. We need a way to track SQL Server Agent job duration over time, and be alerted to anomalies.
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.