Disk IO Tuning for Microsoft SQL Server 4.25 http://spkr8.com/t/1337


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.

Comments on this Talk

Avatar-missing-icon-10 jimncropp, 23 Oct 06:53 PM

You provide some great information in this presentation and others for monitoring performance and resolving related issues. Unfortunately the slides provided are in xml and I am unable to view with the PowerPoint 2007 viewer that you kindly provided the link to. Since I don't work with xml and have very little experience with it these slides are of no value to me. A simple pdf would be greatly appreciated. Thanks.

Avatar-missing-icon-03 Erik, 06 Apr 08:19 AM

Download is not working, unfortunately :(

Have an account? Sign in or register.

Leave a Comment

1 Rating: 4.25

Delivery: 4.00

Content: 4.50