The OpsMgr 2007 MP for SQL 2000 and 2005 has been updated and was released to the MP Catalog on 3/31/2008 (version 6.0.6278.8). This version includes the fixes from all previous versions of the MP and is supported on both OpsMgr 2007 RTM and OpsMgr 2007 SP1. The table below is an excerpt from the MP guide detailing the changes and fixes that were made in this release. I'd like to specifically call out the final bullet in the "Changes to SQL Server 2005 Management Pack" as the behavior of the "Database Status" monitor has been updated to have three states now so it can more appropriate handle DB restore and recovery states.
The March 2008 update to the SQL Server Management Pack includes the following changes:
· 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.
An update to the SQL Server Management pack is available on the download center http://www.microsoft.com/downloads/details.aspx?FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363&DisplayLang=en
Great! Any chance of adding a rule in the next Management Pack that warns when a database file is being grown or shrunk?
Still can't discover a SQL 2000 DB Engine when it is installed on the same server as a SQL 2005 DB engine. Only knows about the 2005 instance.