Released: Public Preview for Microsoft Azure SQL Database Management Pack (6.7.11.0)

  • Article

We are working on significantly updating the Management Pack for Azure SQL Database. Your feedback on this public preview will improve the quality of the final release. Please install the bits from the download location below and send us your feedback. You can comment on this post or send specific feedback to sqlmpsfeedback@microsoft.com. We are looking forward to hearing from you.

This release will bring support for Elastics Pools and Azure AD Authentication among other new features. We are also working on handling monitoring of larger number of databases. We are expecting to improve the scale by the time we RTM. Here are some numbers to give you an idea for this public preview:

  • 2 management servers in resource pool, each server is 3CPU & 7GB RAM (almost identical to Azure Cloud VM — DS2_V2Standard), one server is launching workflows, the other is for High Availability

Azure SQL DB configuration it can healthily monitor: 1 Azure SQL server having 1000 deployed databases

  • 4 management servers in resource pool, each server is 3CPU & 7GB RAM (almost identical to Azure Cloud VM — DS2_V2Standard) , two servers are launching workflows, the others are for High Availability

Azure SQL DB configuration it can healthily monitor: 2 Azure SQL servers, 1000 databases per each (2000 databases in total)

  • 1 management server, 4 CPU & 14GB RAM (Azure Cloud VM — DS3_V2Standard)

Azure SQL DB configuration it can healthily monitor: 2 Azure SQL servers, 1000 databases per each (2000 databases in total)

  • 4 management servers in resource pool, each server is 4 CPU & 14GB RAM (Azure Cloud VM — DS3_V2Standard), two servers are launching workflows, the others are for High Availability

Azure SQL DB configuration it can healthily monitor: 3 Azure SQL servers, 1000 databases per each (3000 databases in total)

You can find the release at: Microsoft System Center Management Pack (Community Technical Preview 1) for Azure SQL Database

Please see below for the new features and improvements. More detailed information can be found in the guide that can be downloaded from the link above.

New Features and Fixes in Microsoft Azure SQL Database Management Pack (Community Technical Preview 1) 6.7.11.0:

  • 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

 

We are looking forward to hearing your feedback.