Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Monitoring, Jobs, SQL Monitor Rss

   Items 1 to 1 of 1   
 

New Custom Metric: Long Running Job

SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.  Read more...
By Press Release 2013/04/05 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,056 reads
   Items 1 to 1 of 1