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 ............................................................................................................................. 8
4 Deploying SQL Server on ME4 Series storage .......................................................................................................... 10
4.1 Volume configuration ........................................................................................................................................ 10
4.2 SQL Server I/O reduction ................................................................................................................................. 11
A Technical support and resources ............................................................................................................................... 14
A.1 Related resources ............................................................................................................................................ 14