SQL Monitor

SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total

  • Article

This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used.


3,002 reads

New SQL Monitor Custom Metric: Percentage of Free Log Space

  • Article

This metric measures the percentage of free space for transaction log files (LDF files). You’ll find this useful if your SQL Server has limited capacity, so you need to maximize existing disk space utilization by minimizing unused space. It will also alert you if the amount of free space drops below the specified thresholds.


3,155 reads

New SQL Monitor Custom Metric: Large Transaction Log Files

  • Article

If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold.


2,422 reads

New SQL Monitor Custom Metric: Untrusted Foreign Keys

  • Article

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.


2,554 reads

New SQL Monitor Custom Metric: Untrusted Check Constraints

  • Article

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.


2,585 reads

New SQL Monitor Custom Metric: Issues found by sp_Blitz

  • Article

This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.


3,470 reads

Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor

  • Article

Wednesday July 25 2012, 6:00pm BST: Learn how you can use SQL Monitor to gather information and alert on extra performance data for your servers and applications, making this tool vital for keeping an eye on your business. In this free webinar David Bick, Product Manager at Red Gate, will give you an overview of SQL Monitor including the new custom metric functionality in v3.

2012-07-24 (first published: )

4,981 reads


Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting


Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021


Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Surprised and Honoured and Proud


I have always been extremely proud to be a Cloud and Datacenter Management MVP,...

Read the latest Blogs


Calculate Target Column

By selpoivre

Hi, I have below table Sum of AP1 = 1764. I need to sql...

Get all information from within a trigger

By hvse

Hello from Portugal. I manage a database for a customer, and this database has...

Function test questionnaire help

By frdrckmitchell7

qq Hi clever people! The following is part of a TEST QUESTIONNAIRE. Although in...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers