Title: Disk IO Tuning for Microsoft SQL Server
Abstract: Tuning disk subsystems for optimal 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 will answer 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 my system for improved 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.
Prerequisites: Understanding of hardware and Windows 2000 and SQL Server server concepts
Rate it! Rate my session and offer feedback here.