Monitor and Server Health Group

 View Only

MS 7 - Monitor Pack for SQL - Updated June 2009 

Jun 15, 2009 02:25 PM

Now includes the following Performance Counters and Health Alerts:

Monitors all Critical NT Events in the Application Log for MSSQLSERVER Source
Monitor Database State for SUSPECT/EMERGENCY/Offline (requires Monitor Windows Configuration to have SQL User configured) (does not return DB name only server and state which I am working on resolving)
SQL Percent Log used > 80%
SQL Server Buffer Manager Cache Size Ratio > 98
SQL DB Size > 10GB (This can be easily changed)
SQL Server Process and Remediation of Service if not running
SQL Server Service and Remediation of Service if not running (Other services like Reporting and Analytical Service can be easily added)
SQL T_Log > 1GB
SQL Server Batch Request/sec > 1000
SQL Server Compilation Requests/sec > 100
SQL Reporting Service Status with Auto Remediation
SQL Analysis Service Status with Auto Remediation
SQL Server Locks
SQL Server Memory Pages/Sec
SQL Server User Connections
SQL Server Access Methods Object:  Full Scans/Sec
SQL Server Backup Device Object: Device Object Throughput/Sec
SQL Server Buffer Manager: Page Life Expectancy < 200
SQL Server Locks Object: Average Wait Time in ms > 500
SQL Server Memory Pages/Sec
SQL Server Page Splits > 200
SQL Server User Connections





Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
zip file
MS 7 SQL Server Pack Basic Updated June 2009.zip   103 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Related Entries and Links

No Related Resource entered.