Share This Post


Public Preview Available for Microsoft Azure SQL Database Management Pack

Microsoft has released the Azure SQL Database Management Pack ( into public preview in hopes that customers will install, test, and provide direct feedback. Specific feedback can be emailed to:

Download: Microsoft System Center Management Pack (Community Technical Preview 1) for Azure SQL Database

Features and fixes in this latest update:

  • 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
  • Added regular expression filtering capability for Azure SQL Database instances and Elastic Pools
  • Improved monitoring efficiency: monitoring target is now defined by monitoring pool; WatcherNode class is considered to be deprecated
  • Improved SCOM Add Monitoring Wizard to reflect the new features of the Management Pack
  • Added health monitoring for Database Geo-Replication
  • Added health monitoring for Elastic Pools
  • Added monitoring for “Average DTU utilization percentage” metric
  • Fixed issue: some rules work only if more than 1% of Microsoft Azure SQL Database space is used
  • Introduced performance improvements to the Management Pack
  • 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

Looking for an awesome, no-nonsense technical conference for IT Pros, Devs, and DevOps? IT/Dev Connections kicks off in San Francisco in 2017!

IT/Dev Connections

Share This Post

Leave a Reply