SQL Server Tuning

• EVA Best Practice
• 64KB NTFS block size
• more RAM
• multiple files to match number of CPU
• use multiple file group
• Log file and tempdb --> RAID 1
• Data --> Raid 5
• Enable NUMA with affinity to each node
• Use SQLIO.EXE from Microsoft to benchmark the disk performance