Tuesday, July 16, 2013

Updated MP: Extended SQL Server MP

Some days ago the updated Extended SQL Server MP is released, version 7.1.8570.3. This MP works with SQL Server versions 2008, 2008 R2 and 2012.

Taken directly from the website:

This management pack augments the existing SQL Server management pack by monitoring for the following changes in your environment:

  • New - Removed the "Collect Process Working Set (SQLServr)" performance collection rule as it was incorrectly configured, targetting the SQL 2008 and 2012 DBEngine class. 
  • New - Created a new class "SQL Server <Version> Computer Role" with discovery rule to support targetting of custom performance collection rules that are not aligned with the SQL instance, but the OS. 
  • New - Created new performance collection rules for SQLServr instance process - Private Bytes, % Processor Time, and Working Set.
  • Monitors database backup status and only alerts for databases which are not part of an Availability Group.  Any database hosted on a secondary replica in an Availability Group is excluded from monitoring for database backup status.
  • Removed all alert rules that monitor the health of mirrored databases as this is adequately covered in the latest release of the SQL management pack.
  • Removed an alert rule which monitors filegroup free space exhaustion, as it is adequately covered in the latest release of the SQL management pack. 
  • Created an additional performance report for database engine instance metrics collected by performance collection rules included in this management pack.

Want to know more? Go here.

No comments: