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.
| Author |
Topic |
|
saglamtimur
Yak Posting Veteran
91 Posts |
 Posted - 2004-03-25 : 17:00:59
|
| What units of measurements are being used in the sql server query analyzer estimated execution plan? estimated I/O cost: 0.0125 --> Is this millseconds or ? estimated CPU cost: 0.000143 --> Is this millseconds or ? ....estimated cost: 0.037722(100%) --> Is this millseconds or ? 100% of what? estimated subtree cost: 0.0377 --> Is this millseconds or ? Thanks in advance... |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-03-25 : 19:05:42
|
| Have a look at the following article:http://www.sql-server-performance.com/query_execution_plan_analysis.asp |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-03-25 : 19:16:57
|
quote:
The unit of measure for the SQL Server execution plan cost is not documented. It is known that the cost values are the same on a given platform for both SQL Server 7.0 and SQL Server 2000, including Standard and Enterprise editions, and all service packs. The I/O costs for the Index Seek and Bookmark Lookup operations depend on the whether the system has up to 1GB of memory or more than 1GB of memory. The CPU cost is the same for all platforms tested.
snippet above is from this article: http://www.sql-server-performance.com/jc_sql_server_quantative_analysis1.asp-ec |
|
|
|
saglamtimur
Yak Posting Veteran
91 Posts |
Posted - 2004-03-25 : 19:25:34
|
| Thanks, helped much. |
|
|
|
|
|
|
Mesurements of execution plan cost