Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #119: What is the query that my stored procedure is running now?

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jan 15, 2020
Today, we have been working on a performance issue where our customer is running a stored procedure but we don't know exactly what is the part of this that is running.    Let me show you an examp...
Updated Jan 15, 2020
Version 3.0
Michael Bourgon's avatar
Michael Bourgon
Brass Contributor
May 16, 2022

this may be a stupid question, but don't y'all use sp_whoisactive? I know it's not an official MS tool, but it's the de-facto standard for this type of thing.