HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

CPU or Page Reads

Submitted by: @import:stackexchange-dba··
0
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.