Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sp_BlitzWho -- Add session level wait stats for 2016+ #895

Closed
BlitzErik opened this issue May 26, 2017 · 2 comments
Closed

sp_BlitzWho -- Add session level wait stats for 2016+ #895

BlitzErik opened this issue May 26, 2017 · 2 comments
Labels
enhancement sp_BlitzWho
Milestone
2017-07

Comments

@BlitzErik
Copy link
Contributor

Do you want to request a feature or report a bug?
Feature

What is the current behavior?
We don't look at overall session level waits in 2016+, we only track current waits.

What is the expected behavior?
We should look at sys.dm_exec_session_wait_stats for more granular breakdown of stuff and things

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
2016+
@BlitzErik
Copy link
Contributor Author

After some thought, this doesn't help us much the way Who/First run.

@BlitzErik
Copy link
Contributor Author

We should cross apply for this to get the top n waits of significance like this in bqs.

@BlitzErik BlitzErik reopened this Jun 8, 2017
@BlitzErik BlitzErik added this to the 2017-07 milestone Jun 28, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement sp_BlitzWho
Projects
None yet
Milestone
2017-07
Development

No branches or pull requests
1 participant
@BlitzErik