Updated Ops Mgr 2007 SQL and Windows Management Packs

October 31, 2008 · Filed Under Operations Manager | 408 views

A couple of recently updated Management Packs for Operations Manager 2007…SQL and Windows Server Operating System. Here’s the updates from the included documentation in the Management Packs. As always, get your Ops Mgr Management Packs here.

The October 2008 release (version 6.0.6321.5) of the Windows Server Operating System
Management Pack includes the following changes:

Various scripts were updated to prevent issues with locale specific number formatting.

SQL Server Management Pack version 6.0.6441.0 includes the following changes:

General Changes

The management pack now includes the SQL Server 2008 discovery and monitoring management packs. SQL Server 2008 monitoring is identical to the SQL Server 2005 management pack, including the new functionality added in this release for SQL Server 2005 monitoring.

Addressed issues with a few performance rules attempting to collect performance counters or instances by the wrong name.

Updated a number of discoveries, rules, and tasks to ensure they use the correct RunAs profiles for discovery and monitoring.

Updated the criteria on a number of event-based rules to make their criteria more specific to reduce alert volumes.

SQL DB Engine discovery will now work on systems that do not have the SQL tools installed.

The SQL Server 2005 and SQL Server 2008 management packs support discovery and partial monitoring of 32-bit instances of SQL components installed on 64-bit operating systems. This is discussed in more detail in the “Supported Configurations” section of this guide.

All monitors are now set to public accessibility, allowing increased customization. Most notably, custom diagnostics and recoveries can now be added.

The “Database Size” and “Log Size” properties of databases are now available as a numeric property, in addition to the string form of the property that already existed.

Updated knowledge for various reports.

Database snapshots are no longer discovered and monitored as if they were a full-fledged database.

The possible states of the “Blocking SPIDs” monitor in all management packs have been changed to better align with the default override behaviors. Previously, the monitor could either be in a “Success” or “Warning” state. The “Warning” state has been replaced with “Error”.

Changes to the SQL Server 2000 Management Pack

The default thresholds for the “Job Duration” have been revised. The numbers were previously an integer corresponding to minutes when it should have been in the format of HHMMSS. The knowledge for this monitor has been updated to more clearly explain the format of the threshold.

Changed the frequency at which the SAPasswordMonitor.vbs script is run from 24 seconds to 24 hours.

Changes to SQL Server 2005 Management Pack

Added monitoring for log shipping with the “Destination Log Shipping Monitor” and “Source Log Shipping Monitor” monitors.

Fixed a few typos and formatting issues with product knowledge in various places.