SQL Server 2000 Management Pack Guide

The Microsoft SQL Server 2000 Management Pack provides both proactive and reactive monitoring of SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability.

This guide was developed with the September, 2004 version of the Microsoft SQL Server 2000 Management Pack. Ensure that you are using the most recent version of the Management Pack by going to http://www.microsoft.com/mom/managementpacks (http://go.microsoft.com/fwlink/?LinkId=33752).

Recommended Knowledge and Skills

To deploy and operate the Microsoft SQL Server  2000 Management Pack, it is recommended that you possess the following knowledge and skills:

• A working knowledge of the Microsoft Operations Manager 2005 (MOM) monitoring features.

• Be familiar with the recommended process for deploying Management Packs as described in Chapter 6, "Deploying MOM 2005 Management Packs," in the Microsoft Operations Manager 2005 Deployment Guide.

• Have an administrative and working knowledge of Microsoft SQL Server 2000.

• Have a working knowledge of databases and Transact-SQL.