Introduction to the SQL Server Management Pack Guide

Applies To: Operations Manager 2007, Operations Manager 2007 R2, SQL Server

The SQL Server Management Pack provides both proactive and reactive monitoring of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.

The monitoring provided by this management pack includes availability and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.

In addition to health monitoring capabilities, this management pack includes dashboard views, extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues.

Document Version

This guide was written based on the 6.4.0.0 Management Pack.

Getting the Latest Management Pack

You can find the SQL Server Management Pack at (https://go.microsoft.com/fwlink/?LinkId=324309).