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 database performance monitoring 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 monitoring 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.
Prerequisites for setting up Microsoft SQL Azure database monitoring: Click here
Using the REST API to add a new Microsoft Azure SQL Database monitor: Click here
Follow the steps given below to create a new monitor:
Go to the Monitors Category View by clicking the Monitors tab. Click on Azure SQL Database under the Cloud Apps table. Displayed is the Azure SQL database bulk configuration view distributed into three tabs:
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 SQL database monitoring metrics in the following tabs:
Note: To monitor Query Statistics, the username and password of the SQL database should be provided in the 'Edit Monitor' page.
| 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(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 |
| Parameter | Description |
|---|---|
| RESOURCE UTILIZATION | |
| CPU Utilization | Average percentage of CPU utilized between the poll interval. |
| DTU Utilization * | Average percentage of Data Transaction Unit (DTU) consumed between the poll interval. |
| IO Utilization | Average percentage of Data IO utilized between the poll interval. |
| DTU UTILIZATION | |
| DTU Limit * | Average limit of Data Transaction Unit between the poll interval. |
| DTU Used * | Average Data Transaction Unit used between the poll interval. |
| DATABASE SIZE | |
| Storage Utilization | Amount of storage space utilized in the database (in percentage). |
| 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 | Maximum amount of storage space available in the database (in GB). |
| CONNECTIONS | |
| Successful connections | Total number of successful connections between the poll interval. |
| Failed connections | Total number of failed connections between the poll interval. |
| Connections Blocked by firewall | Total number of connections that are blocked by firewall between the poll interval. |
| PERFORMANCE STATISTICS | |
| Deadlocks | Total number of deadlocks occurred between the poll interval. |
| Log IO Percentage | Average percentage of log IO between the poll interval. |
| In-memory OLTP storage used percentage | Average percentage of In-Memory Online Transaction Processing storage used between the poll interval. |
| Workers(concurrent requests) used percentage | Average percentage of Workers used between the poll interval. |
| Sessions used percentage | Average percentage of sessions between the poll interval. |
Note: Metrics marked with * can be monitored only in DTU-based Azure SQL Database servers.
| Parameter | Description |
|---|---|
| Average CPU time(ms) | Average CPU time taken to execute this query |
| Total CPU time(ms) | Total CPU 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 |
| Parameter | Description |
|---|---|
| Average IO | Average IO operations for this query |
| Total IO | Total IO operations for 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 |
| Parameter | Description |
|---|---|
| Top CLR queries | |
| 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 | |
| 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 |
| Parameter | Description |
|---|---|
| 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 |
| Parameter | Description |
|---|---|
| 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 |
| Parameter | Description |
|---|---|
| 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 |
| 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 this database is associated if any |
