Solutions in this chapter:

• Managing SQL Server 2000

• Monitoring SQL Server 2000

• Performing SQL Server 2000 Operations

Introduction

The SQL Server 2000 database where your MOM 2005 database is stored is one of the most important systems in your enterprise environment. The Microsoft SQL Server Management Pack provides you with a proactive and reactive way to both monitor and maintain your SQL Server 2000 systems. Ensuring availability through both local and remote connectivity checks, monitoring your configurations, and collecting data concerning your system performance through default thresholds allow for enterprise level monitoring that helps to ensure system integrity and health. This chapter will cover these things as well as how to use the management pack to manage and monitor SQL Server 2000 in your enterprise to take advantage of these resources.

Managing SQL Server 2000

First, make sure that you have a good understanding of the MOM 2005 monitoring features. Make sure you re also familiar with how to deploy management packs as discussed in Chapter 4. It will also help if you can manage and administer SQL Server 2000 and have a working knowledge of databases and Transact-SQL. Basically, this management pack allows you to monitor key data points to ensure the availability of your SQL Servers and related components as well as maintain a reliable day-to-day operation of your SQL Server instances.