Disk IO Tuning for Microsoft SQL Server Newbie
Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. It normally requires years of experience the hard disk subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance, and allow for the most scalability. This session removes the need for those years of experience by answering questions like:
- How does RAID compare to SAN, hard disk to SSD?
- What is needed to properly monitor and tune the performance of my disk subsystem?
- How do I tune my SQL Server for improved IO performance?
Configuring hardware can be very intimidating, especially when the application needs to scale. Learning the best practices, 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: Basic understanding of hardware. Knowledge of Windows operating systems and SQL Server file concepts.

(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP since 2004, Kevin is a founding board member and past president of the international Professional Association for SQL Server (PASS). He has written or co-written several books including SQL in a Nutshell (O’Reilly & Associates), SQL Server MVP Deep Dives (Manning), Pro SQL Server 2008 Database Design and Optimization (APress) and Database Benchmarking: Practical Methods for Oracle & SQL Server (Rampant). Kevin contributes to SQL Server Magazine and Database Trends & Applications Magazine and blogs at SQLBlog.com and SQLMag.com. His twitter handle is @kekline. Kevin is a top rated speaker at conferences worldwide such as Microsoft TechEd, the PASS Community Summit, Microsoft IT Forum, DevTeach, and SQL Connections, and has been active for over 20 years.
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.