SQL Monitor

SQL Monitor

Proactively monitor your SQL Server estate with SQL Monitor 9

Increasingly, organizations need to monitor bigger databases across higher numbers of SQL servers, installed across diverse networks and platforms, including cloud platforms such as Azure. Often, these large estates are still managed by a relatively small team who can struggle to keep up, because their monitoring tools and processes fail to scale. They find that Read more

SQL Monitor

Monitoring SQL Server Security: What’s Required?

A characteristic theme of all the current legislation on the responsible curation of data is that there should be a system for continuously monitoring and analyzing database activity, in real-time. This Database Activity Monitoring (DAM) system must detect anyone, inside or outside the organization, accessing or tampering with information in any database-driven applications that handle Read more

SQL Monitor

Scaling SQL Monitor to Large SQL Server Estates

Most organizations are finding that the size and number of databases that need to be monitored is increasing, unlike the number of people available to do the work. Now that it is possible for the organization to scale out to cloud-hosted databases, the constraints of the available infrastructure have ceased to govern the growth of Read more

SQL Monitor

Using the SQL Monitor Estate Pages

As a DBA responsible for the availability, performance, security and overall health of a set of SQL Servers, you have many plates to keep spinning. You’ll need to respond quickly to avert or resolve query performance and resource contention problems. Each morning as you arrive at your desk, you’ll also need to cast a watchful Read more

SQL Monitor

Avoid running out of Disk Space ever again using SQL Monitor

If your SQL Server runs out of disk space, and it is running a database for an enterprise’s trading application, then the company can’t take money until the DBA fixes the problem. Even the worry of that ever happening is enough to keep a DBA up at night. No wonder, then, that the recent State Read more

SQL Monitor

Monitoring the Application with SQL Monitor: Website Activity

As well as being essential for giving you an overview of the SQL Server installations that you look after, SQL Monitor can also be used in ways that aren’t so immediately obvious. One immediate advantage it has as a monitoring tool is that it isn’t part of any one server, database or application: it is Read more

SQL Monitor

Monitoring Azure SQL Database with SQL Monitor

SQL Monitor provides a full suite of monitoring specific to Azure SQL Database and SQL Elastic Pools. You can therefore use it to monitor all your databases, regardless of whether they are on local physical servers or virtual machines, or in the Azure cloud. Azure SQL Database is just a SQL Server database under the Read more

SQL Monitor

Why is my query suddenly slow?

Sometimes query performance problems sneak into SQL Server after a software release that involves database schema or code changes, and you must hunt down the offending query and tune it. Other times, however, the performance changes for less immediately explicable reasons. I’m sure we’ve all experienced this situation: your system is humming along, and you’ve Read more

SQL Monitor

How to Monitor IDENTITY columns to prevent unplanned downtime

We all try hard to plan for data growth and changing workloads, as we build and adapt our SQL Server systems, and to anticipate potential problems. Some issues, however, take a long time to appear. They lay in wait, unnoticed but not dormant, and if they strike without warning, they can cause severe disruption and Read more

SQL Monitor

On Quickly Investigating a SQL Monitor Custom Security Alert

I recently wrote a series of article that described four SQL Monitor custom metrics, designed purely to monitor for the signs of intrusion, or other unauthorized database changes. These metrics allow you to implement separate strategies for: Detecting SQL Injection attacks – the metric uses Extended Events to capture errors related to incorrect SQL syntax, Read more