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_BlitzFirst -- Wait stats queries/Ignorable waits #1708

Closed
BlitzErik opened this issue Aug 12, 2018 · 1 comment
Closed

sp_BlitzFirst -- Wait stats queries/Ignorable waits #1708

BlitzErik opened this issue Aug 12, 2018 · 1 comment

Comments

@BlitzErik
Copy link
Contributor

BlitzErik commented Aug 12, 2018

Right now, the first and second pass queries that look at wait stats filter out a static list of ignorable waits.

We should be using the global temp table that gets built, like this:

	WHERE EXISTS 
	    (
            SELECT 1/0
	    	FROM ##WaitCategories AS wc
	    	WHERE wc.WaitType = dows.wait_type
	    	AND wc.Ignorable = 0
	    )
@BrentOzar
Copy link
Member

SMART.

BlitzErik added a commit that referenced this issue Aug 14, 2018
... Rather than a static list.

Closes #1708
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

2 participants