Database Reference
In-Depth Information
for-core performance varies significantly between the G6 and Gen8 systems. This is as
you would expect with the advances being achieved regularly with modern processor
technology.
If you don't want to use SAPS and you simply want to compare between different x86
processor types and generations, you can also use publicly available SPECInt
benchmarks.
Table 10.7
presents the SPECInt (
www.spec.org
, CINT2006) results for
the same processor types as listed in
Table 10.6
.
Table 10.7
SPECInt Benchmark Examples Between Different Processor Generations
Note
When using SPECInt or SAPS Benchmarks as a comparison between CPUs
of different generations or types, you should take into consideration that
they were determined at close to 100% system utilization. This means they
are only good as a relative comparison and to translate a CPU utilization
figure on one system to another. You should allow some headroom for
peaks when doing your calculations.
Non-Production Workload Influences on Performance
Your performance testing, benchmarking, baselining, and validation needs to consider
non-production workload influences that may impact performance. The performance of
your environment might be influenced by some or all of the following activities:
AV updates
Backups
Database Consistency Check (DBCC) processes
Index defragmentation
Database statistics update
