SQL Server Health Checks
One of the SQL Server Support Engineers has posted blog entries on how to perform server health checks using Policy-Based Management. You can access his blog using this URL: http://blogs.msdn.com/bartd/archive/2008/09/11/defining-complex-server-health-policies-in-sql-2008.aspx.
The main part of the SQL Server health check revolves around ensuring the disk response times are less than 100ms. The Policy uses ExecuteSQL to query the dynamic management view sys.dm_io_virtual_file_stats to ensure that the disk response time is within this limit. You can extend this policy to query other DMVs for other health checks—for example, the use of excessive parallelism or checking to ensure that cumulative wait stats have not exceeded ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
