Azure SQL Database Waits monitor


Legacy Documentation

Desktop And Mini DBA Server

Legacy Documentation Home alerts analysisservicesalerts analysisservicescpu analysisservicesdashboard analysisservicesdatabases analysisservicesio analysisservicessessions azurealerts azuredatabase azuredatabasehealthcheck azureindexes azurelocks azure security azuresessions azuresql azuresqldatabase azuresqldatabasedashboard azuresqldatabases azure sql server dashboard azuretables azurewaits compare performance baseline connections cpu custom sql server alerts database database query performance databases defaulttrace dm exec query statistics xml documentation errorlog files gettingstarted healthcheck database healthcheck sql server history active history blocking history data storage history deadlocks history files history memory history viewer history waits howtoperformancetuneazuresqldatabase how to performance tune sql server how to sql server performance tuning how to sql server query tuning indexes Installation io License Support locks maintenance windows options performance history security server servergettingstarted Server Installation server memory serveroptions serversecurity servertroubleshooting sql database memory sql execution plan sql extended event sessions sql server activity sql server alert configuration sql server alerts sql server database sql server execution plan view sql server index defrag jobs sqlserverindexfragmentation sql server index fragmentation sql server index maintenance sql server live query statistics sqlserverqueryperformance sql server query performance sql server send slack alerts sql server send teams alerts sql server transaction log sql server wait statistics tables tranlog waits webmonitorconfigure webmonitorconnections webmonitorcurrent webmonitorcustom webmonitorenterprise webmonitorgettingstarted webmonitorhistoric webmonitorinstallation webmonitorio webmonitormemory webmonitoroptions webmonitoroverview webmonitorsecurity webmonitorwaits wmi

Azure Database Waits



The Azure database waits screen is broken into Total \ Current \ Accumulating \ Queue tabs.
When a wait is clicked its description will be shown at the bottom of the screen.

The Total tab shows all waits in the database since the server was restarted.
Azure Database Waits

The current tab displays the waits currently occuring in the database.
The accumulating tab displays the waits since Mini DBA was started.
Click the reset button to reset the accumulaing waits to zero.

Azure Database Accumulating Waits

The queue tab shows waits currently being waited on by the resource queue.

Note that the monitored server is not asked for the waits information unless the waits screen is shown. This means any data shown as soon as you display the screen is as old as last time you viewed the waits screen.
Fresh data won't be got until the next server sample, how long that is depends on your settings.