search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

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

Open BrentOzar opened 2 years ago

BrentOzar commented 2 years ago

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 commented 2 years ago

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

BrentOzar commented 2 years ago

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

BrentOzar commented 2 years ago

I redid another one here: https://github.com/amachanic/sp_whoisactive/pull/89