White Papers

ManualsBrandsDell ManualsConverged InfrastructureGeneral Solution Resources

Table of contents

4 Dell EMC SC Series: Microsoft SQL Server Best Practices | CML1057

4.3.5 SSD considerations .......................................................................................................................................... 15

4.4 SC Series snapshots ........................................................................................................................................ 15

5 Windows setup and configuration .............................................................................................................................. 17

5.1 Allocation unit size ............................................................................................................................................ 17

5.2 MPIO ................................................................................................................................................................. 17

5.3 Partition alignment ............................................................................................................................................ 17

6 Server setup and configuration .................................................................................................................................. 18

6.1 HBA considerations .......................................................................................................................................... 18

6.2 iSCSI considerations ........................................................................................................................................ 18

7 Optimizing SQL Server I/O ......................................................................................................................................... 19

7.1 Memory ............................................................................................................................................................. 19

7.2 Buffer pool extension ........................................................................................................................................ 19

7.3 Persistent memory ............................................................................................................................................ 19

7.4 Database compression ..................................................................................................................................... 19

7.5 Instant file initialization ...................................................................................................................................... 20

7.6 Resource Governor .......................................................................................................................................... 20

7.7 Database design considerations ...................................................................................................................... 20

7.7.1 Database design ............................................................................................................................................... 21

7.7.2 Query design .................................................................................................................................................... 21

7.7.3 Application design............................................................................................................................................. 21

7.7.4 Maintenance ..................................................................................................................................................... 21

A Additional resources ................................................................................................................................................... 22

A.1 Technical support and resources ..................................................................................................................... 22

A.1 SQL Server resources ...................................................................................................................................... 22