Knowledge Center

Navigate topics

Performance – Waits View

Main waits chart

Main wait event Enhanced Chart distributed by the main wait categories: IO waits, Network waits, Backup waits, CPU waits, Non-Page Latch waits, Lock waits, Transaction Log waits, Tempdb waits.

Wait Category Grid

Legend
1 Wait event filters:

  1. Filter by category name
  2. Filter by category type
  3. Filter by description

2 Wait event category expand button (Opens up expanded view) and grid

Column Description
Category The main wait categories are IO waits, Network waits, Backup waits, CPU waits, Non-Page Latch waits, Locks waits, Transaction Log waits, and TempDB waits.
Percent Percent of wait from total in activity at sample time.
Wait Count Total wait events for the selected timeframe.
Total Waits (ms) Total sum wait duration (ms) for the category in the selected timeframe.

 

Wait Category Detailed Grid

Displays the detailed wait events for the selected wait category.

Column Description
Type Type of wait event.
Percent Percent of wait from total in activity at sample time.
Wait Count Total waits for the type for the timeframe.
Total Waits (ms) Total sum wait duration (ms) for the detailed wait event in the timeframe.

Request a demo

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Contact Sales

Fill out your details. 

We’ll get back to you soon.

Request a Proposal.

Fill out your details. 

We’ll get back to you soon.

Contact us

Fill out your details. 

We’ll get back to you soon.

Need professional DBA services?

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Need professional BI services?

Fill out your details. 

We’ll get back to you soon.

Get help from Experda

Fill out your details. 

We’ll get back to you soon.

Request a demo

Fill out your details. 

We’ll get back to you soon.

This website uses cookies to remember you and improve your experience. To find out more see our Privacy Policy.