2

When running sp_blitzFirst @expertmode = 1 the first result set(result set of sp_blitzwho)does not return nearly as many columns and it does in Brent's video. With a little troubleshooting it was uncovered that the reason this is happening is because the calling stored procedure is not passing @expertMode = 1 to sp_blitzWho. To prove that i can run sp_blitzWho and pass @expertMode = 1 in which case the etire result set is returned.

So my question is: Was there a change to latest version of these stored procedures? Where can i find the version that work like the one Brent displays in his video? Thank you for looking in to this. Best Regards.

Improve this question
2
  • 1
    You can report bugs here for sp_BlitzFirst (or any of the first responder toolkit). You can also browse the change history and contribute a fix if you're able to identify and address the underlying issue yourself. Welcome to the network :)
    – Peter Vandivier
    Commented Feb 13, 2020 at 20:58
  • 2
    I'm voting to close this question as off-topic because the solution is (possibly) related to a third-party tool. Please open up an issue via the Github Repository for SQL-Server-First-Responder-Kit.
    – John K. N.
    Commented Feb 14, 2020 at 14:04

1 Answer 1

Reset to default
1

You're watching a 4-year-old video on YouTube, and sp_BlitzFirst no longer works that way.

If you want to run sp_BlitzWho with @ExpertMode = 1, your best bet is to go ahead and call it directly.

Improve this answer
2
  • I would like to run sp_blitzfirst with expertmode = 1 and i can but it does not return the result set you are showing in the video because expertmode = 1 is not passed to sp_blitsWho. To remediate i would have to rewrite all the temp tables. Alternatively, if possible could you point me to the version of code you run in this video? youtube.com/watch?v=pQcdbbmTqX4
    – Steve Rybak
    Commented Feb 14, 2020 at 2:34
  • Ah, see the date on that video? It's 4 years ago. sp_BlitzFirst no longer works that way. If you'd like it to, you can change the default starting parameter for sp_BlitzWho so that it defaults to ExpertMode = 1 instead of 0.
    – Brent Ozar
    Commented Feb 14, 2020 at 11:07

Not the answer you're looking for? Browse other questions tagged or ask your own question.