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 |
|
AskSQLTeam
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." |
|
|
snSQL
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. |
 |
|
|
|
|
|
SQL:BatchCompleted