Modernize Your Microsoft SQL Server Platform and Accelerate Deployments

• 1

  Executive summary
• 2

  Document purpose
• 3

  Audience

• 1

  Market environment

• 1

  Optimized Microsoft SQL Server Platform

• 1

  Optimized Microsoft SQL Server platform
• 2

  PowerEdge Servers

• 1

  Database Optimized Performance Profile in BIOS
• 2

  Disabling unused integrated devices

• 1

  PowerStore Front-end I/O modules
• 2

  Database storage configuration
• 3

  PVSCSI controllers
• 4

  PowerSwitch

• 1

  Maximum Transmission Unit size
• 2

  VMware vSphere

• 1

  Enable ESXi Power Policy
• 2

  VMware ESXi: Round Robin Path Policy
• 3

  Red Hat Enterprise Linux
• 4

  SQL Server Database

• 1

  Resizing TempDB
• 2

  Autogrowth
• 3

  Max Worker Threads
• 4

  CPU affinity
• 5

  Minimum and maximum server memory

• 1

  Database Solution Optimizer (DSO)
• 2

  Reporting module
• 3

  Log module (future functionality)
• 4

  Server module
• 5

  Storage module (future functionality)
• 6

  OS module
• 7

  Network module (future functionality)
• 8

  Database module
• 9

  Virtual module (Future Functionality)

• 1

  Conclusion
• 2

  We value your feedback
• 3

  VMware documentation
• 4

  Enterprise Strategy Group documentation
• 5

  Red Hat documentation