Technical white paper | HP ProLiant DL980 G7 and P2000 G3 MSA Storage
8
Database configuration
The testing for this DL980 G7 solution was performed using a 6.5 TB test database and a workload simulation program. The
performance numbers depicted in this document are output from the simulation tool running both a simple and complex
workload. The test database uses a master filegroup and 7 additional filegroups which represent the 7 partitions.
Table 5. DB Filegroups
Contains master DB file (MDF)
SQL Server 2012 performance metrics
SQL Server 2012 features new indexing features based on columnar storage technology. This new index improves query
performance for a wide range of queries. Throughput performance is now measured using traditional indexes and columnar
indexes (CSI). These metrics are shown below as “Fast Track Average CSI I/O”.
Measured performance
During our performance testing, we use simulated sequential read workloads to gauge performance on each Fast Track
configuration. These tests use workloads with varying sizes ranging from 5 to 40 concurrent queries, running from 30
minutes to 1 hour each. From the results of these tests we determine both logical (how fast data can be read from buffer
cache) and physical (how fast data can be read from physical disk) scan rates. Table 6 below lists the observed scan rates
for this configuration.
Table 6. Measured Scan Rates
Benchmark Logical Scan Rate
Benchmark Physical Scan Rate
This is the average of the physical and logical scan rates
Fast Track Average CSI I/O
This is the average of the physical and logical scan rates with
Column Store Indexing enabled
Maximum Observed Logical Scan Rate
Maximum average scan rate observed during testing
MAXDOP setting used for these results was 30
Resource Governor was set to 5%
These performance metrics were attained using a set of SQL Server 2012 configuration parameters. These parameters are
detailed below in Table 7. Further explanations of some of these settings are found throughout this document.
To Next Page
Loading...
