Home
Microsoft

Updates to SQL Server Management Packs (2008-2016) have been released. We introduced some new features and fixed some issues. You will see that the root folder name has been changed to “Microsoft SQL Server (old)” in all MPs. This is to reflect the change that we are releasing a new version agnostic SQL Server MP that will cover SQL Server versions 2012 and up. You can find more details on that in this blog post. As explained in that blog post, these version specific MPs become legacy and will not be supported once the version agnostic MP is released (coming soon).

Downloads available at:
Microsoft System Center Management Pack for SQL Server 2016
Microsoft System Center Management Pack for SQL Server 2014
Microsoft System Center Management Pack for SQL Server (2008-2012)
Microsoft System Center Management Pack for SQL Server Dashboards

 

SQL Server 2008-2012 MP New Features and Fixes

  • Fixed: “Total DB Space” monitor uses MB-values instead of %-values in its conditions
  • Added “Unavailable Time (seconds)” parameter to “SQL Server Agent Windows Service” monitor
  • Increased SQL Command Timeout up to 120 seconds in order to decrease timeout errors occasionally happen to DB Space workflows on heavily loaded servers
  • Updated all data sources so that SQL Server connections are established with read-only application intent
  • Changed the root folder name to “Microsoft SQL Server (old)”

SQL Server 2014 MP New Features and Fixes

  • Added “Unavailable Time (seconds)” parameter to “SQL Server Agent Windows Service” monitor
  • Updated “Service Pack Level” monitor to set SP3 as default
  • Updated “Resource Pool Memory Consumption” data source to make it check if a database replica is readable before querying it
  • Increased SQL Command Timeout up to 120 seconds in order to decrease timeout errors occasionally happen to DB Space workflows on heavily loaded servers
  • Fixed exception treating in “Resource Pool Memory Consumption” data source
  • Changed the root folder name to “Microsoft SQL Server (old)”

SQL Server 2016 MP New Features and Fixes

  • Added “Unavailable Time (seconds)” parameter to “SQL Server Agent Windows Service” monitor
  • Updated all data sources so that SQL Server connections are established with read-only application intent
  • Updated “Service Pack Level” monitor to set SP2 as default
  • Updated “Resource Pool Memory Consumption” data source to make it check if a database replica is readable before querying it
  • Fixed exception treating in “Resource Pool Memory Consumption” data source
  • Increased SQL Command Timeout up to 120 seconds in order to decrease timeout errors occasionally happen to DB Space workflows on heavily loaded servers
  • Fixed exception treating in “Resource Pool Memory Consumption” data source
  • Disabled by default XTP counters belong to “SQL Server 2016 XTP Databases” category (We no longer recommend to use them)
  • Changed the root folder name to “Microsoft SQL Server (old)”

Dashboards MP

No changes introduced; increased the version number to 7.0.15.0 to comply with the current version of SQL Server management packs



We are looking forward to hearing your feedback.