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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Query Permormance

Author  Topic 

rokhri
Starting Member

10 Posts

Posted - 2011-01-18 : 11:25:58
Does decrease in CPU value (when comparing old and new query performance), is an indication of better query performance?

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-01-18 : 11:32:55
http://connectsql.blogspot.com/2011/01/sql-server-which-is-more-important-for.html?utm_source=BP_recent
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-01-18 : 12:17:10
It can be. CPU cost does not take into consideration what else is going on on the server. But it is a practical value. The Query cost is only a theoretical value.
Go to Top of Page
   

- Advertisement -