Share This Post

Azure

Public Preview Available for Microsoft Azure SQL Database Management Pack

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

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