Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display Estimated Execution Time - Client Execution Time Expand / Collapse
Author
Message
Posted Saturday, May 12, 2012 5:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 24, 2013 12:22 PM
Points: 24, Visits: 105
I am currently learing about query optimization. Can someone tell me how to interpret within "Display Estimated Execution Time" the "Client Execution Time". I just processed a simple query and the Client Execution Time was quoted at 16:50:30. I was concerned that it meant that my query would take 16 Hours, 50 Minutes and 30 Seconds. Though I haved searched for a while trying to find the interpretation, I finally decided to just run the query and see how long it took. The query took 3 minutes and 4 seconds. Now I am really confused. Can someone interpret this into English for me?
Post #1299176
Posted Saturday, May 12, 2012 6:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 24, 2013 12:22 PM
Points: 24, Visits: 105
Through further research I have found that the time represented by the "Client Execution Time" is the time in which the "Display Estimated Execution Plan" is ran. It is not any estimate of the amount of time in which it would take to execute the query.

So with all of that said, does anyone know how to find an estimated execution time for a query before it is actually ran for the first time?
Post #1299180
Posted Saturday, May 12, 2012 10:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:06 PM
Points: 36,711, Visits: 31,160
To the best of my knowledge, no such tool exists. Certainly, not an accurate one. Even the actual execution plan is frequently wrong when comparing things such as % of Batch.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1299214
Posted Thursday, September 27, 2012 2:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 27, 2012 2:29 PM
Points: 2, Visits: 20
Client Execution Time is the time you ran the query.
Post #1365495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse