Tag Archives: #Management Pack

SCOM: Updated SQL Server Management Packs v6.7.7.0

7 Replies

New versions of the SQL Server management packs are out! They are available from the below links:

Note: Be aware that there have been some serious issues with previous versions of the SQL management packs this year. I cannot stress enough the need for testing before using these in a live environment.

SQL Server 2016: here
SQL Server 2014: here
SQL Server 2008 / 2012: here
SQL Dashboards: here

New in this version

SQL Server 2008 / 2012

  • Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
  • Fixed issue: “Set DB offline” task does not work when the database is in Availability Group
  • Fixed issue: user policy discovery script fails with “Invalid namespace “ROOT\Microsoft\SqlServer\ComputerManagement12″‘ error
  • Fixed issue: Always On console task does not work
  • Updated the visualization library

SQL Server 2014 / 2016

  • Fixed issue: “Set DB offline” task does not work when the database is in Availability Group
  • Fixed issue: Always On console task does not work
  • Updated the visualization library

Dashboards

  • Fixed issue: expanding “arrow” has low-contrast color when a health group is collapsed in Instance view (High-Contrast #2 color scheme)
  • Fixed issue: in Web console, Dashboards continuously send requests to the database
  • Fixed issue: not the first object gets selected in the object list after drill-down
  • Fixed issue: horizontal scroll position resets after refreshing the Instance view
  • Fixed issue: “No Data” message is displayed on some tiles after upgrading Dashboards management pack from version 6.7.2.0 to 6.7.4.0 or later version
  • Fixed issue: on Web console, Dashboards crash when drilling down from Datacenter view to Instance view
  • Restored the correct group order in SQL Server Summary dashboard views

Loading

Management Pack Recap – September 2016 Wave

Leave a reply

This is a summary of the wave of Management Packs that were released in September 2016. Information and download location in the links provided:

SQL (Community Technical Preview 2) MP v6.7.5.0 – here
Windows Server 2012 DHCP MP v6.0.7301.0 – here
.NET Application Performance Monitoring with Visual Studio Application Insights MP (Preview) – here
NiCE DB2 MP 4.10 – here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Loading

SCOM: MP for .NET Application Performance Monitoring with Visual Studio Application Insights

Leave a reply

A new preview management pack if you which extends the APM functionality to include Visual Studio Application Insights get it here

Here is a nice set of installation instructions.

Note that this is a preview so I would suggest extensive testing before using in a live environment.

Loading

SCOM: Updated Windows Server 2012 DHCP MP v6.0.7301.0

2 Replies

An update has been released for the Windows Server 2012 DHCP MP version 6.0.7301.0 is available here.

What’s new

  • If the property scope id length of the failover server watcher class exceeded the max length, then Failover Server Watcher was not being discovered and hence could not monitor DHCP failover servers. The fix ensures that discovery is successful.
  • In a DHCP server with multiple scopes, if two or more scopes have same name when the alert raise for one scope it automatically raises the alert for another same scope name. The fix ensures that alerts are sent only for generated scope.

Loading

SCOM: MP update SQL (Community Technical Preview 2) v6.7.5.0

3 Replies

Technical preview 2 of the new SQL management packs are out for preview, get them here.

Updates:

Dashboards

  • Improved Dashboards performance
  • Fixed issue: Regular\Virtual group tile will show 0 objects if user adds a new group before the previous one has been saved
  • Fixed issue: virtual group filtering for Generic Distributor does not work
  • Fixed issue: tooltips on some menus appear in unexpected places
  • Fixed issue: Web Console is crashing upon right-clicking the Hamburger menu
  • Fixed issue: button captions are cropped in some dashboard localization packs
  • Fixed issue: instance dashboard displays data for the item that is the first in the list if no items appear after applying a filter
  • Fixed issue: the first group object is not in focus after clearing “Filter” field if there were no search results
  • Fixed issue: Summary dashboards appear to be in a strange state if one installs only Dashboards MP without SQL MPs
  • Fixed issue: Bulk Add Tiles does not trigger the refresh action
  • Fixed issue: object and alert counters of Virtual groups containing real groups display zeros
  • Fixed issue: an error appears in Web Console when using keyboard for navigation in “Add Aggregated Monitor” dialog
  • Fixed issue: unexpected scrolling behavior in the instance view when using mouse scroll
  • Fixed issue: markup of the dialog for adding classes gets broken when the scrollbars are displayed
  • Fixed issue: wrong width value of the Edit dialog
  • Fixed issue: there is no refresh action after saving the edited Virtual Group configuration
  • Fixed issue: white-screen exception when working with a dialog in Web Console
  • Fixed issue: datacenter and instance queries fail when a special set of classes is selected

SQL Server 2016 / 2014 / 2012 /2008 / 2005

  • Added support for configurations where computer host names are longer than 15 symbols
  • Added “Event ID” to descriptions of all the alerts generated by the alerting rules
  • Deprecated “Run As Account does not exist on the target system, or does not have enough permissions” rule
  • Added 2 rules for alerts generating when there are problems with execution of the monitoring workflows scripts on the following agents: “MSSQL: Monitoring failed” and “MSSQL: Monitoring warning”
  • Added “MSSQL 2016: Discovery warning” rules to generate alerts when there are non-critical problems with execution of the discovery scripts (warning events in the Operations Manager log)
  • Changed “MSSQL 2016: Discovery failed” rules to generate alerts for only critical errors during executing discovery scripts
  • Improved error logging in the MP scripts
  • Fixed some issues in the scripts, which could lead to unstable work with WMI
  • Fixed the issue when not all available performance counters were presented at “All Performance Data” view in Memory-Optimized Data sub-folder
  • Added a new overridable parameter to monitor “Stale Checkpoint File Pairs Ratio” in order to ignore databases having the number of checkpoint file pairs less than the threshold (300 by default)
  • Made “Resources Pool Memory Consumption (rollup)” enabled by default
  • Updated the visualization library

Loading

Management Pack Recap – August 2016 Wave

Leave a reply

This is a summary of the wave of Management Packs that were released in August 2016. Information and download location in the links provided:

SCCM MP v5.00.8239.1009  – here
SQL Server MP (Community Technical Preview 1) v6.7.3.0 – here
UNIX and Linux MPs v7.5.1060.0 – here

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them

Loading

SCOM: SQL Server MP (Community Technical Preview 1) v6.7.3.0

Leave a reply

Another update for the SQL Community Technical Preview management packs this time we have updates for the SQL Server MPs and no changes to the dashboards. Get the MPs here.

SQL Server 2014 / 2016:

  • Disabled Memory-Optimized Data Garbage Collection Fill Factor monitor and rule by default
  • Disabled Memory-Optimized Data workflows for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

SQL Server 2008 / 2012

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • Removed from the installer SQL 2005 MP files as no longer supported
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

Loading