White Papers

16 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
Database file and volume layout test parameters Table 2
Configuration Parameters
EqualLogic SAN One PS6110X (2.5", 24 10 K SAS drives,900 GB)
RAID type
RAID 50
SQL DB volume Configuration
SQL DB Files- Volume size
•
Primary Data File (.mdf) – 100GB
• LineItem Table DataFile1 (.ndf) – 600 GB
• Order Table (.ndf)-300 GB
• All other tables (.ndf)–200 GB
• Log File (.ldf)-100 GB
• Tempdb-600GB
Data Warehouse Workload Parameters
Database load & Workload
generation
TPC-H from Benchmark Factory
Database size
300 scale (~620 GB including data and indexes)
Number for users/streams 6 (As per TPC-H standard, the minimum required
streams/users to be run for a 300 scale Database is 6)
Queries
22 TPC-H queries per user
SQL Server Memory (Max
memory allocation) in GB
117.7 GB (92% of (128 GB RAM)
SQL Server parameters
-E, -T1117 and lock pages in memory
CPU 4* Intel® Xeon® Processor E5-4620 @2.20 GHz,8 Cores
per socket
In order to test these parameters, a baseline test was first performed using just the default setting and
system performance was measured. The same test was repeated after setting the startup parameters and
lock pages in memory settings to measure the performance. The results are shown in Figure 5.