SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Monitoring, Metrics Rss

   Items 1 to 2 of 2   

SQL Monitor Custom Metric: Tables Without Clustered Indexes

This metric by Fabiano Amorim measures the number of tables without clustered indexes defined that contain more than 1000 rows per database. This is good practice to help improve query performance.  Read more...
By 2015/04/14 | Source: SQL Monitor Metrics | Category: custom metrics
Rating: (not yet rated)  Rate this |   Briefcase | 7,400 reads

SQL Monitor Metric: Processes in a runnable state (scheduler query)

Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.   Read more...
By Press Release 2013/12/03 | Source: SQL Monitor Metrics | Category: monitoring
Rating:  Rate this |   Briefcase | 3,555 reads
   Items 1 to 2 of 2   
custom metrics (1)    
processes (1)    
schedulers (1)