SQL Server Performance

how to get actual cost of an execution plan

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by brian.qin, Dec 17, 2006.

  1. brian.qin New Member

    Does 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
  2. joechang New Member

    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

Share This Page