PDF

Azure SQL DB Sensor

This sensor allows you to monitor the performance and behavior of the databases managed in Azure SQL DB. Azure SQL DB is Microsoft’s cloud database service, that enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.

Azure SQL DB sensor allows you to monitor failed/successful connections or connections blocked by a firewall; to control data and CPU resources by monitoring their average values as well as the occupied memory space and usage percentage. It also makes it possible to verify the data space used, for example when the upper limit is reached. Thanks to this sensor you'll have insight into the utilization of the service and databases, ensuring optimal performance.

Options

This sensor requires credentials for Azure subscription (Application (Client) ID, Tenant ID, and Client Secret Value).

Alerts

  • Data space used > 90%
  • SQL DB process memory usage > 90%
  • SQL DB process CPU usage > 90%

Performance Metrics

  • Connections\Failed - Number of failed connections
  • Connections\Successful - Number of successful connections
  • DTU\% Avg. DTU - Average DTU (Database Transaction Unit) Percentage
  • DTU\Avg. DTU Limit - Average DTU (Database Transaction Unit) Limit. Applies to DTU-based databases
  • DTU\Avg. DTU used - Average DTU (Database Transaction Unit) used. Applies to DTU-based databases
  • DWU\% DWU - Maximum DWU (Data Warehouse Units) percentage. Applies only to data warehouses
  • DWU\DWU Limit - Maximum DWU (Data Warehouse Units) limit. Applies only to data warehouses
  • DWU\DWU Used - DWU (Data Warehouse Units) used. Applies only to data warehouses
  • Log\Log Backup Storage Size [bytes] - Maximum log backup storage size in bytes. Applies to vCore-based and Hyperscale databases
  • Log\% Avg. Log IO - Average Log IO percentage. Not applicable to data warehouses
  • Log\Tempdb Log File Size [KB] - Maximum tempdb log file size in KB. Not applicable to data warehouses
  • Log\% Tempdb Log Used - Maximum tempdb Percent Log Used. Not applicable to data warehouses
  • Process\% Cache Hit - Maximum percentage of a cache hit
  • Process\% Cache Used - Maximum cache used percentage
  • Process\% Avg. Data IO - Average data IO percentage
  • Process\% Avg. Sessions - Average sessions percentage. Not applicable to data warehouses
  • Process\% SQL Server Process Core - Maximum CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses
  • Process\% SQL Server Process Memory - Maximum memory usage as a percentage of the SQL DB process. Not applicable to data warehouses
  • Process\Number of Deadlocks - Number of deadlocks. Not applicable to data warehouses. A deadlock is caused when two or more transactions hold locks that the other transactions require. Blue Matador detects deadlocks in Azure SQL by monitoring the deadlock metric on your SQL databases
  • Resources\Avg. Data Space Allocated [bytes] - Average allocated data storage in bytes
  • Resources\Application CPU Billed -Number of application CPU billed (vCore per second). Applies to serverless databases
  • Resources\% Avg. Application CPU - Average application CPU percentage. Applies to serverless databases
  • Resources\% Application Memory - Application memory percentage. Applies to serverless databases
  • Resources\Base Blob Storage Size [bytes] - Maximum base blob storage size in bytes
  • Resources\Avg. CPU Limit - Average CPU limit
  • Resources\% CPU - CPU percentage
  • Resources\% Avg. vCore Used - Average number of v-Core used
  • Resources\Differential Backup Storage Size [bytes] - Cumulative differential backup storage size in bytes. Applies to vCore-based databases. Not applicable to Hyperscale databases
  • Resources\Data Storage Size (GB) - Total data storage size (GB)
  • Resources\Disaster Recovery Storage Size (GB) - Disaster recovery storage size (GB)
  • Resources\Snapshot Storage Size (GB) - Snapshot storage size (GB)
  • Resources\Full Backup Storage Size [bytes] - Maximum full backup storage size in bytes. Applies to vCore-based databases. Not applicable to Hyperscale databases
  • Resources\% Avg. Local TempDB - Average local tempdb percentage. Applies only to data warehouses
  • Resources\% Memory - Maximum memory percentage
  • Resources\Snapshot Backup Storage Size [Bytes] - Maximum cumulative snapshot backup storage size in bytes
  • Resources\Data Space Used [Bytes] - Maximum data space used in bytes. Not applicable to data warehouses
  • Resources\% Data Space Used - Maximum data space used percent. Not applicable to data warehouses or hyperscale databases
  • Resources\Tempdb Data File Size [KB] - Maximum tempdb Data File Size in KB. Not applicable to data warehouses
  • Resources\% Resources Allocated Per Workload Group - Maximum percentage of resources allocated per workload group
  • Resources\% Cap's Resources Allocated Per Workload Group - Maximum percentage of the specified cap's resources per workload group
  • Resources\% Resources Allowed For Workload Group - A hard limit on the percentage of resources allowed for the workload group, taking into account the Effective Min Resource Percentage allocated for other workload groups
  • Resources\% Effective Min Resource For Workload Group - Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum
  • Resources\% Avg. Workers - Average workers percentage. Not applicable to data warehouses
  • Resources\% Avg. In-Memory OLTP storage - Average in-memory OLTP storage percent. Not applicable to data warehouses
  • Request\Workload Group Active Queries - Number of active queries within the workload group queries
  • Request\Workload Group Query Timeouts - Queries that have timed out for the workload group
  • Request\Queries Queued - Number of queued queries across all workload groups
  • Request\Workload Group Queued Queries - Number of queries queued within the workload group
  • Request\Queries Active - Number of active queries across all workload groups
  • Request\Requests Blocked - Number of requests blocked by firewall

Reports (Data Collectors)

By default, the sensor adds a report containing Process\% SQL Server Process Core, Process\% SQL Server Process Memory, and Resources\Avg. Data Space Allocated [bytes] charts. These metrics will be collected and available as a report or through Performance Trend Viewer.

azureclouddatabasesql