Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2006-12-22 : 20:28:55
aynur writes "Hi,
I wonder what does Duration property of SQL:BatchCompleted event mean?
does it the time spent in SQL Server DB, or the time the the client got the answer, does it include the time which is being spent in the network."

Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-12-22 : 20:57:24
It's server time only. To see client stats that take account for how long the data takes to cross the network, turn on Show Client Statistics in Query Analyzer.
Go to Top of Page

- Advertisement -