patternMinor
CPU or Page Reads
Viewed 0 times
cpureadspage
Problem
While comparing query performance should i go for CPU values or Page Reads. On live server (with better hardware) a query is showing different CPU when i test it on my local machine. But Page Reads remains same.
Solution
Most systems are still I/O-bound, not CPU-bound. If you have a SQL Server system that is not running SSDs and CPU is trumping memory and/or I/O, there is probably a very serious problem. So I would focus on steering queries toward plans that optimize I/O.
Context
StackExchange Database Administrators Q#21260, answer score: 2
Revisions (0)
No revisions yet.