I've tried "Display Estimated Execution Plan," which provides a very large graph with percentages that is perhaps kind of helpful, but I'm hoping someone can get my started by pointing me in the right direction here:
I have a very complex and long stored procedure that in turn calls other stored procedures.
The stored proc is taking too long to run and I'm guessing I have an inefficient query or am missing an index on a table somewhere.
(I tried a low-tech approach of adding select 'here' statements to see where it's getting hung up but I've determined that I can't trust the output as it seems to be buffered or slowing down in statements that can't be taking a long time to complete.)
Ideally, it would be nice if Microsoft provides a tool that shows each SQL statement from beginning to end of running the stored proc with the number of milliseconds spent executing those statements, in a two column table (not a graph), like this:
select blah blah 100 ms
update blah blah 100 ms
Then I could affect the offending statement(s).
Does such a tool exist?