White Papers

34 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
Columnstore index on the LineItem table ( 6 users) – SAN HQ pool view Figure 14
Table 6 summarizes the results from the above SANHQ graphs.
SAN HQ results summary Table 6
Performance metrics No columnstore index Columnstore index on LineItem table
Read/Write %
95.9/4.1
87.1/12.1
Read IO size (KB)
180.81
95.18
Write IO size (KB)
63.84
63.84
Read latency (ms)
148.72
66.03
Write latency (ms)
16.22
2.57
Read IO rate (MB/sec)
921.13
540.55
Write IO rate (MB/sec)
13.74
53.25