Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
waveform
Yak Posting Veteran
93 Posts |
 Posted - 2011-12-08 : 01:11:32
|
| Hi,In SSMS for sql2008, I'm running a query and looking at the execution plan, but I can't see where it shows how long SQL Server actually took to complete the query.I can turn on "Include Client Statistics", but not sure which is the result I need. There's "Client processing time", "Total execution time" and "Wait time on server replies".Which of those shows the query duration at SQL Server's end? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-08 : 01:22:02
|
| for getting query duration make use of sql server profiler and use statement completed counter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
waveform
Yak Posting Veteran
93 Posts |
Posted - 2011-12-09 : 05:14:13
|
| Thanks for that! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 05:24:35
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Getting total query execution time