Description:

Tuning disk subsystems for optimal SQL Server 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.