New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.Read more
When the tempdb database is heavily used, processes in any database on the instance will be forced to wait, due to contention as the SQL Server engine tries to manage allocation pages in tempdb. Phil Factor shows how to monitor for signs of trouble.Read more
With simple integration, SCOM and Redgate Monitor combine breadth and depth, infrastructure-wide observability plus SQL Server insight. The result is faster incident response, smarter use of DBA time, and monitoring that scales with growth and new technologies.Read more
This article explains the Azure-tailored metrics and alerts in Redgate Monitor that track use of the limited compute resources available to an Azure SQL Elastic Pool, and to each of the databases in it.Read more
Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.Read more
Provides a PowerShell monitoring script for errors, warnings and critical events on the Windows server hosting your SQL Server instance, including the failed server login attempts that would accompany a brute-force password attack.Read more
A monitoring tool must provide us with an understanding of the often-complex performance patterns that databases exhibit when under load, so that we can predict how they will cope with expansion or increase in scale. It must also helps us spot the symptoms of stress and act before they become…Read more
If we know how a database is likely to be attacked, we can arrange our lines of defense, and install the monitors required to detect any attempts. However, some types of attack are difficult to imagine, so we also need our monitoring tool to be adaptable, so that it…Read more
Kathi Kellenberger introduces the new Estate monitoring pages in Redgate Monitor 9, and explains how they will help DBAs monitor and safeguard the security, stability and availability of all servers in their care.Read more