SQL Server Performance Forum – Threads Archive
how to get actual cost of an execution planDoes SQL SERVER 2005 provide any way to allow us to obtain the ACTUAL costs (both I/O and CPU) for each node of an execution plan? Thanks, Brian
there is the plan cost, which originally represented a model of the cost structure for SQL Server 7.0, probably some ancient 4xPentium Pro 200MHz or at best a 2 x Pentium II 300MHz.
personally, i think the model was seriously screwed up because MS did not assign a serious HW performance expert to do the calibration work anyways, the cost model a substantially changed in SQL 2005, removing many of the silly things in the 7.0 and 2000 model still, the plan cost is not intended to represent a true cost on your particular system use SET STATISTICS IO and TIME or profiler to get this