Released: Microsoft Azure SQL Database Management Pack (6.7.28.0)

We are happy to announce the release of Azure SQL DB Management Pack! We have significantly enhanced the feature set in this release. Some of the highlights are support for Azure AD authentication, health monitoring for database geo replication, health monitoring for elastic pools, and performance improvements. We will be blogging about performance improvements in the coming weeks. You can download the management pack and find a summary of features at:

Microsoft System Center Management Pack for Microsoft Azure SQL Database

 New Features and Fixes

  • Azure Resource Manager is now supported: the previous versions of the Management Pack used T-SQL queries to SQL Server system views to get information on the databases health and performance; now, the Management Pack can also get this information from Azure REST API (this is a preferred option)
  • Multiple subscriptions and multiple servers are now supported
  • Added support of Azure AD authentication
  • Improved monitoring efficiency: monitoring target is now defined by monitoring pool; WatcherNode class is considered to be deprecated
  • Added health monitoring for Database Geo-Replication
  • Added health monitoring for Elastic Pools
  • Added monitoring for “Average DTU utilization percentage” metric
  • Added regular expression filtering capability for Azure SQL Database instances and Elastic Pools
  • Improved SCOM Add Monitoring Wizard to reflect the new features of the Management Pack
  • Introduced performance improvements to the Management Pack
  • Improved error handling in Add Monitoring Wizard
  • Optimized performance rules notation: all Object Names are standardized; Instance Names are not used anymore
  • Updated the guide to reflect all the changes
  • Updated the visualization library
  • Fixed Server Exclude list filter: a server name could not contain whitespaces
  • Fixed display strings: Azure Portal naming style is applied
  • Fixed issue: some rules work only if more than 1% of Microsoft Azure SQL Database space is used

We are looking forward to your feedback.