tigertoolbox
tigertoolbox copied to clipboard
Creating one new table to load waits byCount. Fixing query for waits by Duration
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