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

SET STATISTICS XML OFF to avoid getting sp_WhoIsActive's execution plan #88

Open
BrentOzar opened this issue Jun 10, 2022 · 3 comments
Open
Assignees
Labels
enhancement New feature or request

Comments

@BrentOzar
Copy link

Every now and then, I accidentally run sp_WhoIsActive in a window with actual plans turned on. Putting SET STATISTICS XML OFF at the top just disables the actual plan output.

I'm doing a quick pull request in the Github web site, and it's warning me about mixed line endings, so the pull request might be bigger:

Screen Shot 2022-06-10 at 4 31 40 AM

If that's an issue, you can close my pull request and just add the command to the top of any other pull request.

@amachanic
Copy link
Owner

This is a good idea but where's your PR?

@BrentOzar
Copy link
Author

That's really weird - you can see the commit in the changelog above, not sure why Github isn't showing it. Eventual consistency?

@BrentOzar
Copy link
Author

I redid another one here: #89

@erikdarlingdata erikdarlingdata added the enhancement New feature or request label Aug 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants