White Papers

Table of contents
3 Dell EMC PowerVault ME4 Series and Microsoft SQL Server | 3923-BP-SQL
Table of contents
Revisions............................................................................................................................................................................. 2
Acknowledgements ............................................................................................................................................................. 2
Table of contents ................................................................................................................................................................ 3
Executive summary ............................................................................................................................................................. 4
Audience ............................................................................................................................................................................. 4
1 Introduction ................................................................................................................................................................... 5
2 Best practices overview ................................................................................................................................................ 6
3 SQL Server design considerations ............................................................................................................................... 7
3.1 OLTP workloads ................................................................................................................................................. 7
3.2 OLAP/DSS workloads ........................................................................................................................................ 7
3.3 Mixed workloads ................................................................................................................................................. 7
3.4 ME4 Series configuration ................................................................................................................................... 7
3.5 Validating the storage design ............................................................................................................................. 9
4 Deploying SQL Server on ME4 Series storage .......................................................................................................... 11
4.1 Volume configuration ........................................................................................................................................ 11
4.2 SQL Server I/O reduction ................................................................................................................................. 12
A Technical support and resources ............................................................................................................................... 15
A.1 Related resources ............................................................................................................................................ 15