pCodeLab

Azure Sql Server real time utilization data

January 24, 2020 • ☕️ 1 min read

Every project that uses Azure Sql Server needs a way of monitoring tha database load. The portal of Azure gives a beautiful graph on the utilization of the load of the server.

Azure Portal Graph

I wanted to understand where this data came from and I ended up using sys.dm_db_resource_stats.

  SELECT end_time as EndTime,
    avg_cpu_percent as AvgCpuPercent,
    avg_data_io_percent as AvgDataIoPercent,
    avg_log_write_percent as AvgLogWritePercent,
    avg_memory_usage_percent as AvgMemoryUsagePercent,
    xtp_storage_percent as XtpStoragePercent,
    max_worker_percent as MaxWorkerPercent,
    max_session_percent as MaxSessionPercent
  FROM sys.dm_db_resource_stats
  ORDER BY end_time

Query result

The query returns 256 rows of the last hour of database utilization. Now you can create a real-time graph using the technology you like most.

Custom graph