O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required