Azure SQL Database Service

Learn about the other Azure service support on our Azure docs.

Sensor (Data Collection)

Tracked Configuration

Server Details Description
Name Server name
Location Server location
FQDN The fully qualified domain name of the server
State The state of the server
Version The version of the server.
Database Details Description
Name Database name
Location Database location
Max Size The max size of the database expressed in bytes
Status The status of the database
SKU The name and tier of the SKU
Elastic Pool Details Description
Name Elastic pool name
Location Elastic pool location
Max Size The storage limit for the database elastic pool in bytes.
State The state of the elastic pool (Creating, Disabled, Ready)
Min Capacity The minimum capacity all databases are guaranteed
Max Capacity The maximum capacity any one database can consume
SKU The resource model definition representing SKU

Database Metrics

Metric Unit Aggregation Description
DTU
DTU Limit Count Average Total DTU utilization of the database
DTU Used Count Average DTU utilization of the database
DTU Percentage Percent Average DTU utilization percentage
CPU
CPU Percentage Percent Average CPU resources consumed by all database sessions
Connections
Successful Connections Count Total Total number of successful connections
Failed Connections Count Total Total number of failed connections
Blocked By Firewall Count Total Total number of connections blocked by the firewall
Deadlock
Deadlocks Count Total Deadlocks
Storage
Storage Bytes Maximum Total database size
Storage Percentage Percent Maximum Database size percentage
IO
Data IO Percent Average Data I/O utilization
Log IO Percent Average Log I/O utilization
Other
Workers Percent Average Concurrent workers (requests) of the database’s service tier limit by the Microsoft Azure SQL Database
Sessions Percent Average Concurrent sessions of the database’s service tier limit
In-memory OLTP Storage Percent Average In-memory OLTP Storage (XTP Storage)

Elastic Pool Metrics

Metric Unit Aggregation Description
eDTU
eDTU Limit Count Average Total eDTU utilization of the database
eDTU Used Count Average eDTU utilization of the database
eDTU Percentage Percent Average eDTU utilization percentage
CPU
CPU Percentage Percent Average CPU resources consumed by all database sessions
Storage
Storage Limit Bytes Average Total database size
Storage Used Bytes Average Total database size
Storage Percentage Percent Average Database size percentage
IO
Data IO Percent Average Data I/O utilization
Log IO Percent Average Log I/O utilization
Other
Workers Percent Average Concurrent workers (requests) of the database’s service tier limit by the Microsoft Azure SQL Database
Sessions Percent Average Concurrent sessions of the database’s service tier limit
In-memory OLTP Storage Percent Average In-memory OLTP Storage (XTP Storage)

Health Checks

The Azure SQL Database sensor will conduct custom health checks and execute them every minute. If the checks fail for at least one minute, an issue will be raised to inform the user.

Database Health Description
State Unhealthy state is caused by the database being unavailable. A database can be unavailable if one of the following conditions is true:
  • The database has been set offline by the user
  • The database is being restored from backup
  • The database is being recovered
  • The database has been corrupted
  • The database has been set to the Emergency state by the administrator
  • The database is in the process of being created by copying another database
Size Azure SQL Database is running out of space. Warning limit is at 80% and the critical limit is at 90% of the used size
DTU The total DTU utilization for Azure SQL Database is getting closer to max DTU limit. Warning limit is at 75% and the critical limit is at 85% of the DTU utilization
eDTU The total eDTU utilization for Azure SQL Database is getting closer to max eDTU limit. Warning limit is at 75% and the critical limit is at 85% of the eDTU utilization

Note

Metrics are pulled every minute, which is the resolution Azure provides for monitoring of these services.