---
id: post/demiliani-com/13254
type: post
title: "Dynamics 365 Business Central: understanding the Database Wait Statistics page."
summary: The Database Wait Statistics page in Business Central shows how Azure SQL database time is spent waiting for resources rather than executing queries. Understanding wait categories, task counts, wait times, signal waits, and their ratios helps identify performance bottlenecks like CPU pressure, lock contention, or I/O delays.
tier: community
language: en
tags:
  - performance
  - database
  - wait statistics
  - diagnostics
  - monitoring
  - bottleneck
  - optimization
  - azure sql
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:57:15.885Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 258c636a4c4b980dc70a4618d7c3fb302a130cc29c8ba8726925755a5a6d1807
evidence:
  - kind: blog
    url: https://demiliani.com/2026/01/28/dynamics-365-business-central-understanding-the-database-wait-statistics-page/
    title: "Dynamics 365 Business Central: understanding the Database Wait Statistics page."
    date: "2026-01-28"
    commit: null
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/page/9520
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "13254"
source_id: demiliani-com
source_name: Stefano Demiliani
url: https://demiliani.com/2026/01/28/dynamics-365-business-central-understanding-the-database-wait-statistics-page/
published_at: "2026-01-28T09:28:36.000Z"
author: Stefano Demiliani
full_text: false
words: 2147
quotes: []
code_objects_mentioned:
  - page Database Wait Statistics
systems:
  - platform
  - administration
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://demiliani.com/2026/01/28/dynamics-365-business-central-understanding-the-database-wait-statistics-page/embed/
  image: https://demiliani.com/wp-content/uploads/2026/01/d365bc_databaseviewstats_00.png
  image_alt: null
  image_w: 1047
  image_h: 323
  site_name: Stefano Demiliani
  favicon: https://demiliani.com/wp-content/uploads/2022/09/sd_wordpress_logo.png?w=32
  probed_at: "2026-10-07T11:51:05.908Z"
---

# Dynamics 365 Business Central: understanding the Database Wait Statistics page.

[Read the post](https://demiliani.com/2026/01/28/dynamics-365-business-central-understanding-the-database-wait-statistics-page/) · Stefano Demiliani (Stefano Demiliani, MVP) · 2026-01-28 · 2147 words · tier community · reviewed (checked by Opus)

> The Database Wait Statistics page in Business Central shows how Azure SQL database time is spent waiting for resources rather than executing queries. Understanding wait categories, task counts, wait times, signal waits, and their ratios helps identify performance bottlenecks like CPU pressure, lock contention, or I/O delays.

## Key points

- The Database Wait Statistics page shows data from sys.dm_db_wait_stats for the tenant database. The waits are grouped into categories and add up from the time the database started.
- The page has six columns: Wait Category, Waiting Tasks Count, Wait Time, Max Wait Time, Signal Wait Time and Database start time.
- To get the signal wait ratio, divide signal wait time by wait time. Below 10% is normal and above 20% means significant CPU pressure.
- Rank categories by total wait time rather than count, and divide wait time by count to get the average wait per task.
- To see what the database waited on during a specific period, take snapshots at two points in time and compare them.

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- [page 9520 "Database Wait Statistics"](../../objects/page/9520.md)

## Context

- Features: Database Wait Statistics page, Wait Category analysis, Signal Wait Time ratio calculation, Lock contention detection, CPU pressure identification, I/O performance monitoring, Average wait per task calculation, Historical wait statistics trending

Source: Stefano Demiliani, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.