Shane O’Neill has an experience:
You have code that keeps coming up as a high consumer of CPU on our systems? OK?
It had gotten to the stage where it kept appearing in
sp_WhoIsActive
? What’s that? And should it not be “whom is active”? Well, agree to disagree.Let’s see the code so. Wow, that’s a small scroll bar! Yeah, that’s one of ours.
I should note that “Who is active?” is correct, as the sessions we are inquiring after are the subject of the question rather than the direct or indirect object, and there is no prepositional phrase which would affect the decision.