1

I am executing a stored procedure and want to get the duration of all the procedure, but I get only the duration of each block.

enter image description here

How to do that?

Thanks :)

Andriy M
  • 76,112
  • 17
  • 94
  • 154
Misha Zaslavsky
  • 8,414
  • 11
  • 70
  • 116
  • 2
    There isn't really a way to see total duration in the grid in the free version, since we "flatten" the call stack and don't show the enclosing proc call, what let to it, etc. In the PRO version, [the full stack feature will let you see this (click for an example)](http://i.stack.imgur.com/F2wIh.png). What you can do in the free version is right-click that top grid, choose Copy > All, and paste into Excel. In Excel you can perform all kinds of aggregates that you need. – Aaron Bertrand Jun 03 '14 at 12:53
  • @AaronBertrand Thanks, that's answers to my question, you can change the answer to a Post answer, so you will get the bounty. – Misha Zaslavsky Jun 03 '14 at 13:05

1 Answers1

1

You can find the answer in the following pages:

Measuring Query Performance : "Execution Plan Query Cost" vs "Time Taken"

and

https://dba.stackexchange.com/questions/24617/can-i-get-ssms-to-show-me-the-actual-query-costs-in-the-execution-plan-pane

Community
  • 1
  • 1
Pascut
  • 3,291
  • 6
  • 36
  • 64