SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What is Query Duration?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 10/05/2005 :  18:34:17  Show Profile  Visit bakerjon's Homepage  Reply with Quote
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

USA
37466 Posts

Posted - 10/05/2005 :  18:39:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
145 Posts

Posted - 10/05/2005 :  18:44:08  Show Profile  Visit bakerjon's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000