- 25 Sep 2020
- 2 Minutes to read
SQL Database Monitoring
- Updated on 25 Sep 2020
- 2 Minutes to read
Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine. SQL Database is a high-performance, reliable, and secure cloud database that you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.
Associating Azure SQL Database to Composite Application
Associating Azure SQL Database into Composite Application providing authorized credentials, username and password of the database.
Serverless360 facilitates Data Monitoring and Query monitoring on Azure SQL database. Data Monitoring on Azure SQL Database metrics does not require SQL credentials (username and password) where as to perform Query monitoring valid SQL credentials are required.
Below is an illustration on associating an Azure SQL Database to a Composite Application.
Once an Azure SQL Database is associated with a Composite Application in Serverless360, it is possible to monitor the Azure SQL Database in various perspectives using the monitors in Serverless360.
Monitor Azure SQL Database based on Metrics
If the intention is to understand the efficiency, reliability or consumption of the Azure SQL Database then the choice should be a Serverless360 Data Monitor. Data Monitoring can be configured for an Azure SQL Database on an extensive set of metrics.
The table below lists down the combination of metrics to monitor the Azure SQL Database in various perspectives using Serverless360 Data Monitor.
|Monitoring Purpose||Metrics to Choose|
|Check the used percentage of CPU, Data IO, Log IO, DTU||CPU Percentage (%),Data IO Percentage (%), Log IO Percentage (%), DTU Percentage (%)|
|Check the Data space used||Data space used (Bytes)|
|Check the number of Successful, Failed connections to the database||Successful Connections (Count), Failed Connections (Count)|
|Check the number of calls blocked by Firewall||Blocked by Firewall (Count)|
|Check the number of Deadlocks detected||Deadlocks (Count)|
|Check the used percentage of Data space||Data space used percent (%)|
|Check the DTU Limit||DTU Limit (Count)|
|Check the DTU Used||DTU used (Count)|
|Check the Data space allocated||Data space allocated (Bytes)|
Data Monitor can be configured for various combination of metrics to meet the monitoring requirements. Data monitor on Azure SQL Database can be set as in the illustration below
Note: All the Azure SQL Databases associated within a Composite Application can be monitored on their metrics.
Query Based Monitoring on Azure SQL Database
If the monitoring requirement is to get alerts when a scalar query fired on the Azure SQL Database fail to meet the expected value, then the choice should be Serverless360 Watch Monitor.
A scalar query can be associated to a watch monitor along with the warning and error threshold values. The query will be executed on the Azure SQL database at the specified frequency in the watch monitor. If the result of the query violates any of the threshold values defined, alerts will be sent through the notification channels configured in the watch monitor.
Note : To perform Query Monitoring on an Azure SQL Database, it should be associated with the Composite Application providing username and password.