OpsMgr 2007: Updated Microsoft SQL Server 2000/2005 Management Pack Available

  • Article

Just a quick heads up that we released an updated version of the Microsoft SQL Server 2000/2005 Management Pack.  This management pack monitors Microsoft SQL Server 2000 and SQL Server 2005 (obviously) and includes the following features and changes:

Overview

The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.

Features

  • Active Directory Helper Service
  • SQL Server Agent
  • Backup
  • Databases and Tables
  • DBCC
  • Full Text Search
  • Log Shipping
  • Clustering
  • DB availability
  • Replication monitoring
  • Agent jobs
  • Backup Query Engine
  • Replication
  • Web Assistant
  • SQL XML

General changes in this update

  • The “Transaction Log Space Free (%)” monitor was made public for both SQL 2000 and SQL 2005 to allow for further customization.
  • Some corrections were made and additional detail provided in the “Key Monitoring Scenarios” sections of this guide.
  • Removed the hard-coded exception for jobs with a specific name from the “A SQL job failed to complete successfully” rules for both SQL 2000 and SQL 2005.
  • Fixed an issue with the scripts used to calculate DB free space which was preventing some databases from having their free space correctly monitored on SQL installations that did not have DBs with contiguous IDs.
  • Corrected typographical errors.

Changes to SQL Server 2000 Management Pack

  • Fixed an issue where incorrect free space values were being calculated for some SQL 2000 databases.

Changes to SQL Server 2005 Management Pack

  • A fix was made to address issues with collection of performance data from specific instances of Analysis Services.
  • Significant changes were made to the “Database Status” monitor in the SQL 2005 MP.  The monitor now has three states reflecting good, bad, and neither.  The possible database states have been realigned into these categories which will reduce “false-positive” alert volumes specifically when log-shipping and database backups are occurring.

Management Pack Release History

  • Initial Release 3/23/2007 Version 6.0.5000.0
  • 12/21/2007 - updated version 6.0.6247.5
  • 3/31/2008 - Updated version 6.0.6278.8

For more information and to download the updated management pack visit https://www.microsoft.com/downloads/details.aspx?FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363&DisplayLang=en

J.C. Hornbeck | Manageability Knowledge Engineer