
Disk Optimization for SQL Servers & Databases
One of the easiest ways to improve the lifetime performance of a SQL Server database is proper setup of the physical and logical drives. While it’s an easy technique, proper disk subsystem configuration is often overlooked or handled by a member of the IT staff other than a SQL Server DBA. Table of Contents: Storages specific terms Best RAID level for your system? Best practices for drive and physical file layout configuration Drive layout examples for SQL Server systems All too often the disk subsystem, including the disk array, is configured based only on storage capacity, with no question of