MS SQL Server Setup Tips
It is important to setup your windows server correctly for optimum SQL Server performance. The following outlines the most important setup steps to get right. Format Disks with NTFS allocation unit size of 64K Use VMDK Paravirtual or RDM disks Set Max Degrees Of Parallelism to # Cores Set Max Server Memory 90% of system …