tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Creating one new table to load waits byCount. Fixing query for waits by Duration

Open asavioliMSFT opened this issue 4 months ago • 0 comments

With this PR, I'm suggesting 2 changes for proc SpLoadQueryProcessingComponent_TopWaits:

1 - Currently, there is only one table named tbl_OS_WAIT_STATS_byDuration, but we are loading on it the waits byCount from the sp_server_diagnostics. I've changed the query to load the waits byDuration into the table tbl_OS_WAIT_STATS_byDuration

2 - Creating an additional table tbl_OS_WAIT_STATS_byCount to load the waits byCount on it

asavioliMSFT avatar Jun 12 '25 15:06 asavioliMSFT