Chapter 7. Choosing a Storage System for Microsoft SQL Server 2005

The most common performance problems found in Microsoft SQL Server database systems involve the disk storage system, where SQL Server data and log files are stored. Selecting the appropriate storage system to store your SQL Server files and configuring that storage properly can have a huge effect on the performance of your database system. This is because SQL Server performance is extremely dependent on I/O performance, as accessing database data is all about performing I/O—reads and writes.

Chapter 4, describes in detail how disks drives work and perform, what the various RAID ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.