I presented this topic at the Collaborate 2018 conference.
My slides can be found here.
A couple of the slides included simplified queries so the text would fit on a single screen and remain legible.
To find who is using temp, a more functionally robust query can be found here:
/2018/03/08/who-is-using-temp-and-what-are-they-doing/
Similarly, the who is blocking whom query has a fuller version here:
/2018/03/04/who-is-blocking-whom-and-what-are-they-doing/
Thanks to all who attended and asked questions and/or commented.