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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What is Query Duration?

Author  Topic 

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-10-05 : 18:34:17
This is going to sound like a silly question, but I'll explain.

What exactly does query duration (such as found when running a trace) include?

Is it just how long the engine takes to execute the query, or does it also include how long the resource sat in the UMS queue and/or time to put in the return buffer and/or time to return the data to the client and receive acknowledgement from the client that it received the data (and/or other steps in the process)?

I ask because I'm seeing some interesting things with wait stats that don't necessarily depict what I'm seeing in a trace. Any help here is greatly appreciated. Links to sites describing the lifecycle of a SQL Server request are also appreciated. I've not been able to find these yet.

Thanks in advance oh wise and benevolent yaks!



Now I know, and knowing is half the battle!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-05 : 18:39:58
The duration is how long it took the query to run. It does not include the amount of time it took to send the results to the client or anything else, just how long it took inside SQL Server.

Tara
Go to Top of Page

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-10-05 : 18:44:08
That's what I thought, and it seems to be confirmed from the things I saw today. Anybody have some links to info on life of a SQL request.

Now I know, and knowing is half the battle!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013

Go to Top of Page
   

- Advertisement -