THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
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

 

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) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement