Viewing 7 posts - 1 through 8 (of 8 total)
GilaMonster (6/28/2009)
June 28, 2009 at 11:04 am
GilaMonster (6/28/2009)
rw30 (6/28/2009)
then the only way to know server side query execution time is to run SSMS on the server ? right ?
Or with a fast network where SQL's not...
June 28, 2009 at 10:17 am
Was that via profiler or SSMS's query execution time (bottom right). The latter does include network trip time and everything as it's a display of the time until management studio's...
June 28, 2009 at 9:54 am
GilaMonster (6/28/2009)
rw30 (6/28/2009)
GilaMonster (6/28/2009)
SET STATISTICS TIME ONand then run your query. There will be fairly detailed time breakdowns in the messages pane.
results shown after enabling SET STATISTICS TIME are...
June 28, 2009 at 9:03 am
GilaMonster (6/28/2009)
SET STATISTICS TIME ONand then run your query. There will be fairly detailed time breakdowns in the messages pane.
results shown after enabling SET STATISTICS TIME are almost exactly...
June 28, 2009 at 8:32 am
what I would like to get is the same what you get inOracle by setting SQL_TRACE=TRUE
and then extracting the trace file by TKPROF
June 28, 2009 at 8:24 am
Viewing 7 posts - 1 through 8 (of 8 total)