THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Tibor Karaszi

Query cost

I often get a question about the unit for a query plan's "Estimated Subtree Cost". I use to say that "this is just a "tick"". But I now have a better explanation to point to:

http://blogs.msdn.com/sqlqueryprocessing/archive/2006/10/11/What-is-this-cost.aspx


Published Thursday, August 23, 2007 10:31 AM by TiborKaraszi
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jason Haley said:

August 23, 2007 9:13 AM
 

jchang said:

thats just speculation, even though AT guesses the correct units

I talked about this subject in my presentations at Connection, HP World and CMG 2003-04.

depending on the version of BOL you have, follow the chain

S2K BOL: Administering SQL Server > Managing Servers > Setting Configuration Options > cost threshold for parallelism Option

The cost refers to an estimated elapsed time in seconds required to execute the serial plan on a specific hardware configuration.

SQL 2005

Administering the Database Engine > Managing Servers > Setting Server Configuration Options >

or search: cost threshold for parallelism Option

Steve Sadler actually found this in the documentation for me, as I only heard it without hard document

December 20, 2007 9:47 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement