White Papers

4 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
7.3 SQL Server Best Practices ............................................................................................................................................ 45
7.3.1 SQL Server startup parameters ................................................................................................................................... 45
7.3.2 Database volume creation .......................................................................................................................................... 45
7.3.3 Files and file groups ...................................................................................................................................................... 45
7.3.4 Data file growth ............................................................................................................................................................. 45
7.3.5 Transaction log file growth ......................................................................................................................................... 46
7.3.6 Tempdb file growth ...................................................................................................................................................... 46
7.3.7 Columnstore Index ....................................................................................................................................................... 48
8 Conclusion ................................................................................................................................................................................ 50
A Configuration details ............................................................................................................................................................... 51
B Columnstore index .................................................................................................................................................................. 53
Additional resources ....................................................................................................................................................................... 54