Edit

Share via

Database Wait Statistics in Dynamics 365 Business Central

  • Article

You can check the performance of your database by looking at the information provided by Database Wait Statistics in Business Central. You can see how long the previous queries had to wait with the wait type indicating the reason of the wait. The wait times give you a quick idea about the database performance and where it can be optimized. There can be different reasons for a query to wait, for example, a query can wait for a resource that isn't free or the wait can be because of a queue. For details about the types of wait in SQL database, see Types of Waits. The Database Wait Statistics presents a table with information divided into these types of columns:

  • Wait category type, which states reasons for a query to wait. For example, CPU, Idle, Lock, Buffer IO, and so on. For more information about these objects, see SQL Server, Wait Statistics Objects.
  • Different wait time counters, for example, Wait Time in ms, Max Wait Time in ms, and Signal Wait Time in ms.
  • Waiting tasks count shows the total count of each wait category that has happened.
  • Database start time indicates the time when database was first started or is restarted.

Note

The wait times aren't live. These statistics show the wait times for the queries which are completed from the time the database was started or when it was reset.

You can also emit this data to telemetry and can analyze it in Application Insights. To do this, choose the Emit telemetry icon from the tab. To set the telemetry signal for the application, see Monitoring and Analyzing Telemetry. To know more about which information you'll get in Application Insights and how to analyze it, see Analyzing Database Wait Statistics Telemetry.

sys.dm_os_wait_stats (Transact- SQL)
How to work with a Performance problem
Performance Article for Developers