cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Different waits in different tabs (SQL, Waits, Programs, Etc.)

Jump to solution

I have noticed that there are sometimes HUGE differences for wait times given separate categories.  This, for example is the total wait times for the various tabs for one of our servers on March 3:

SQL Tab:              6:42:33

Waits Tab:           62:45:01

Programs Tab:    54:29:04

Databases Tab:   63:11:18

Machines Tab:     13:20:43

DB Users Tab:     58:47:21

Files Tab:             0:28:21

Drives Tab:          0:33:22

Plans Tab:          10:59:45

I think that I understand why most of these are different, but I'm trying to understand the SQL tab.  Is it so much lower than total waits because it is only the sum of the top 15 most "waited" statements?

Tags (2)
0 Kudos
1 Solution
Level 14

You are exactly correct. It's the aggregate for the top 15 X within the timeframe and context you are viewing in the UI. If you have fewer than 15 databases, that will represent all waits observed for your instance during our quick poll.

View solution in original post

1 Reply
Level 14

You are exactly correct. It's the aggregate for the top 15 X within the timeframe and context you are viewing in the UI. If you have fewer than 15 databases, that will represent all waits observed for your instance during our quick poll.

View solution in original post