Tuesday, April 1, 2008

Updated SQL Server 2000/2005 Management Pack

Download the updated SQL Server 2000/2005 Management Pack here.

Quick Details
File Name: SQL Server System Center Operations Manager 2007 MP.msi
Version: 6.0.6278.8
Date Published: 3/31/2008

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


The SQL MP Guide in this download is updated.

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.
• Fixed an issue where incorrect free space values were being calculated for some SQL 2000 databases.
• 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.