White Papers

40 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
CPU utilization comparison Figure 19
6.4.3 Scaling the arrays and user load- TPC-H
In this test, both the arrays and the workload were scaled. As arrays were scaled to two, the number of
databases and users were also doubled to push more load on the two arrays. Two databases were
deployed with 12 users running 264 queries. The volume configuration used for the two array scaling test
is shown in Test Configuration #2 of Figure 20 and the configuration parameters shown in Table 9.
Volume layout for the SAN scaling studies Figure 20
15
20
46
56
0
10
20
30
40
50
60
1xarray 2xarrays
% CPU Utilization
CPU utilization
Average CPU Utilization
Max CPU Utilization