Disk IO Tuning for Microsoft SQL Server
Tuning disk subsystems for optimal I/O performance is typically the domain of very experienced, enterprise DBAs. It normally takes many years of exposure to the hard disk subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance, and allow for the most scalability. This session answers questions like:
- How do I configure my hard disks? Do I need RAID?
- What are the types of RAID and which kind is best for my application?
- How does RAID compare to SAN?
- How many disks will I need for my high-performance application?
- What is needed to properly monitor the performance of my disk subsystem?
- How do I tune SQL Server to improve IO performance?
Setting up hardware can be very intimidating, especially when the application needs to scale. Learning the tips and techniques described in this session will help you avoid costly mistakes and serve as the foundation for the long-term success of your SQL Server environment.
Download it! Download the zipped slide deck here (uncompresses in MS-Power Point 2007 format).
Rate it! Rate my session and offer feedback here.