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.

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

sp_Blitz - check 152 showing wrong number for % total wait time #324

Closed
BrentOzar opened this issue Jun 28, 2016 · 2 comments
Closed

sp_Blitz - check 152 showing wrong number for % total wait time #324

BrentOzar opened this issue Jun 28, 2016 · 2 comments

Comments

@BrentOzar
Copy link
Member

In sp_Blitz, check 152 shows any wait types that exceed a certain threshold. In the details, it says:

3614.9 hours of waits, 54.3 minutes average wait time per hour, 100.0% of waits, 6.2% signal wait, 1348685661 waiting tasks, 9.6 ms average wait time.

That example is from a server that only had 1 wait type (CXPACKET) that was listed in the result. Note that it says 100.0% of waits - but it's not actually 100.0% of waits. It's only 100.0% of the waits that were listed in sp_Blitz's output - the server had other waits.

BrentOzar added a commit that referenced this issue Jun 28, 2016
Probably the world’s worst fix, but this used windowing functions and
ain’t nobody got time for that.
@BrentOzar
Copy link
Member Author

Ready for someone to test.

BrentOzar added a commit that referenced this issue Jun 28, 2016
#324 sp_Blitz removed % of waits in details
@BrentOzar
Copy link
Member Author

Tested, merged, closing.

@BrentOzar BrentOzar self-assigned this Jun 28, 2016
@BrentOzar BrentOzar added this to the 2016-07 milestone Jun 28, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant