Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. You can download the management pack and find a summary of features at:
Microsoft System Center Management Pack for Microsoft Azure SQL Database
We have made improvements in the area of monitoring large number of databases. We would like to share some numbers that will hopefully help you setup the right configuration for your large systems. Even if you don't have large number of databases, the performance gains as a result of this work will be available for the lower end of the scale.
In our performance lab in Azure, every management server had the same configuration as following:
Management servers used for launching Azure SQL MP workflows were dedicated only for monitoring Azure SQL Database. Actually, we used a dedicated management server pool for monitoring Azure SQL Database and just changed the number of management servers in this pool.
In Azure SQL Database, we had the following configuration:
Azure SQL Servers: 10
Database Elastic Pool (per each server): 5 (Basic Pool 50 eDTU)
Database (per each pool): 100
Total: 5000 databases (500 per each server)
Results:
2000 databases can be monitored by a pool having a single management server;
5000 databases can be monitored by a pool having 6 management servers (3 are used for launching workflows, the others are in standby)
We are looking forward to your feedback.
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in