Microsoft Azure SQL database monitor
Microsoft Azure SQL Database Monitor - An Overview
Azure SQL DB is a relational database-as-a-service (DBaaS) hosted in the Azure cloud. Data is hosted, managed and provisioned in Microsoft data centers. Since organizations constantly deal with large amounts of data at a global scale, it goes without saying that a proper Microsoft Azure SQL database management tool is highly recommended to monitor and understand what is going on while storing and retrieving huge amounts of data constantly on cloud.
Applications Manager's Azure SQL monitoring tool provides monitoring of Azure SQL performance metrics and query statistics so that users can be informed of any performance issues happening in their Azure SQL database. It eases your monitoring needs by keeping a close watch on Azure SQL database monitor metrics along with proactive Azure SQL database query monitoring, providing deep insights into the performance of your Azure SQL environments.
In this help document, you will learn how to get started with Azure SQL database performance monitoring by keeping a close watch on various Azure SQL performance metrics with the help of Applications Manager.
Creating a new Microsoft Azure SQL Database monitor
To learn how to create a new Microsoft Azure SQL Database monitor, click here.
Monitored Parameters
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' in the tooltip under Microsoft Azure in the Cloud Apps table, and select the SQL Database monitor. This action will display the bulk configuration view for Azure SQL Database in three tabs:
- Availability tab gives the Availability history for the past 24 hours or 30 days.
- Performance tab gives the Health Status and events for the past 24 hours or 30 days.
- List view enables you to perform bulk admin configurations.
SQL Azure database monitoring tool like Applications Manager eases out your Microsoft Azure SQL database management needs by providing visibility into your Azure SQL cloud environments along with Azure SQL database query monitoring altogether in a single window, providing all the vital Azure Azure SQL Database Monitoring metrics in the following tabs:
Note:- Data shown for all the metrics in Azure SQL Database monitor is collected via Azure REST APIs (Azure Service APIs and Azure Monitor API)
- To monitor Query Statistics, the username and password of the SQL database should be provided in the Edit Monitor page.
Monitor Information
| Parameter | Description |
|---|
| Database Name | Name of the Azure SQL Database |
| Database Username | Username of the SQL Server of this particular database |
| Database Server | Name of the SQL server |
| Resource Group Name | Resource group to which the SQL database is associated. |
| Timeout | Timeout Duration (in seconds) |
| Associated Groups | The monitor groups to which this monitor is associated. |
| Last Polled At | Specifies the time at which the last poll was performed. |
| Next Poll At | Specifies the time at which the next poll is scheduled. |
Overview
| Parameter | Description |
|---|
| RESOURCE UTILIZATION |
| CPU Utilization | Average percentage of CPU utilized over a specified poll interval. |
| DTU Utilization * | Average percentage of Data Transaction Unit (DTU) consumed over a specified poll interval. |
| IO Utilization | Average percentage of Data IO utilized over a specified poll interval. |
| DTU UTILIZATION |
| DTU Limit * | Average limit of Data Transaction Unit over a specified poll interval. |
| DTU Used * | Average Data Transaction Unit used over a specified poll interval. |
| DATABASE SIZE |
| Storage Utilization | Amount of storage space utilized in the database (in %). |
| Allocated Database | Amount of storage space allocated for the database (in MB). |
| Used Database | Amount of storage space used in the database (in MB). |
| Total Database Size | Maximum amount of storage space available in the database (in GB). |
| CONNECTIONS |
| Successful connections | Total number of successful connections over a specified poll interval. |
| Failed connections | Total number of failed connections over a specified poll interval. |
| Connections Blocked by firewall | Total number of connections that are blocked by firewall over a specified poll interval. |
| PERFORMANCE STATISTICS |
| Deadlocks | Total number of deadlocks occurred over a specified poll interval. |
| Log IO Percentage | Average percentage of log IO over a specified poll interval. |
| In-memory OLTP storage used percentage | Average percentage of In-Memory Online Transaction Processing storage used over a specified poll interval. |
| Workers(concurrent requests) used percentage | Average percentage of Workers used over a specified poll interval. |
| Sessions used percentage | Average percentage of sessions over a specified poll interval. |
Note: Metrics marked with * can be monitored only in DTU-based Azure SQL Database servers.
Top Queries by CPU
| Parameter | Description |
|---|
| Query No. | Indicates the rank of the query based on CPU Time. |
| Average CPU time | Average CPU time taken to execute this query (in ms). |
| Total CPU time | Total CPU time taken to execute this query (in ms). |
| Average Execution time | Average time taken to execute this query (in ms). |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed |
Top Queries by IO
| Parameter | Description |
|---|
| Query No. | Indicates the rank of the query based on IO. |
| Average IO | Average IO operations for this query |
| Total IO | Total IO operations for this query |
| Average Execution time | Average time taken to execute this query (in ms). |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed |
Top CLR Queries and Waits
| Parameter | Description |
|---|
| Top CLR queries |
| Query No. | Indicates the rank of the query based on CLR time. |
| Average CLR time(ms) | Average CLR time taken to execute this query. |
| Total CLR time(ms) | Total CLR time taken to execute this query. |
| Average Execution time(ms) | Average time taken to execute this query. |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed. |
| Top Waits by waiting tasks |
| No. | Indicates the rank of the waiting tasks based on Wait Time. |
| Waiting tasks | Number of waiting tasks |
| Wait time(ms) | Total wait time |
| Average Wait time(ms) | Average wait time by the waiting tasks |
| Signal time(ms) | Signal time by the waiting task |
| Wait type | Type of the waiting tasks |
Top Slow Running Queries
| Parameter | Description |
|---|
| Query No. | Indicates the rank of the query based on Average Execution Time. |
| Average Execution Time(ms) | Average execution time for this query |
| Maximum Execution Time(ms) | Maximum execution time for this query |
| Minimum Execution time(ms) | Minimum execution time for this query |
| Number of Executions | Number of times this query was executed |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed |
Frequently Executed Queries
| Parameter | Description |
|---|
| Query No. | Indicates the rank of the query based on Execution count. |
| Execution count | Number of times this query was executed |
| Average Execution time(ms) | Average execution for this query |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed |
Most Blocked Queries
| Parameter | Description |
|---|
| Query No. | Indicates the rank of the query based on Average Time Blocked. |
| Average time blocked(ms) | Average time this query was blocked |
| Total time blocked(ms) | Total time this query was blocked |
| Average Execution time(ms) | Average time taken to execute this query |
| Query | Indicates the query executed. |
| Last Execution time | The time when this query was last executed |
Configuration
| Parameter | Description |
|---|
| Database name | Name of the Azure SQL Database |
| Database status | Status of the SQL database |
| Database Location | Location of the SQL database |
| Database Server | Name of the SQL Server |
| Resource Group Name | Resource group to which the SQL database is associated |
| Database Edition | Edition/Pricing tier of this database |
| Database Creation Date | Date on when this database was created |
| Database Earliest Restore Date | Oldest restore point |
| Elastic Pool | The Elastic pool to this database is associated if any. |
