SQL Monitor

SQL Monitor

Monitoring your servers and databases with SCOM and SQL Monitor

SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy. Read more

SQL Monitor

Azure SQL Elastic Pools and SQL Monitor

This article explains the Azure-tailored metrics and alerts in SQL 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

SQL Monitor

Tracking the number of active sessions on a database using SQL Monitor

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

SQL Monitor

Checking on Failed Server Logins, Server Errors and Warnings using SQL Monitor

Armed only with PowerShell and SQL Monitor, Phil Factor offers a solution that will alert you quickly to a whole range of Windows errors, warnings and critical events, including the failed server login attempts that would accompany a brute-force password attack on the Windows Server hosting your SQL Server instance. Read more

SQL Monitor

Monitoring SQL Server Performance: What’s Required?

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 problems that affect the service, and understand better what was happening within a database when an intermittent problem started. Read more

SQL Monitor

Proactively monitor your SQL Server estate with SQL Monitor 9

Faris Hilmi introduces the new Estate pages in SQL Monitor 9, which provide estate-wide views of disk space usage, backups and other jobs, and application of recent SQL Server updates and patches. Using them, a team can review the overall health of all their servers and databases, identify potential issues before the escalate into real problems, and assign priorities, proactively. Read more

SQL Monitor

Monitoring SQL Server Security: What’s Required?

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 can collect a more diffuse collection of metrics, and then help us determine the reason for any sudden change in the patterns of access . Read more

SQL Monitor

Scaling SQL Monitor to Large SQL Server Estates

Tony Davis describes the features and capabilities of SQL Monitor that allow it to scale smoothly to monitor a growing estate of servers and databases, while still providing a single, simple dashboard that gives the team all of the essential SQL Server metrics and alerts, establishes baselines, and detects trends in behavior. Read more

SQL Monitor

Using the SQL Monitor Estate Pages

Kathi Kellenberger introduces the new Estate monitoring pages in SQL 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

SQL Monitor

Avoid running out of Disk Space ever again using SQL Monitor

SQL Monitor not only collects all the disk and database growth tracking data you need, automatically, but also analyses trends in this data to predict accurately when either a disk volume will run out of free space, or a database file will need to grow. Read more