Session

BOS29-200: Storage and I/O Best Practices for SQL Server
Presenter: Andrew Kelly
Breakout Session - Level 200 (Intermediate)

SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most neglected or mis-configured areas of a SQL Server instance. Here we will focus on the best practices related to how SQL Server works with the underlying storage subsystem and what you can do to maximize the relationship between the two. The core topics will include discussions on SANs vs. Direct Attached storage, Raid Groups, Caching, Types of I/O, Number of Files & their placement and more.

Code and Slides

Microsoft Most Valuable Professional (MVP) logo Andrew Kelly
Partner, Solid Quality Mentors
Andrew J. Kelly is a Partner & Mentor with Solid Quality Mentors and lives in Myrtle Beach, South Carolina. He has over 20 years experience with relational databases and application development on both UNIX and Windows platforms but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001.

Email: akelly@solidq.com
Website: http://www.solidq.com
Blog: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Twitter: http://twitter.com/gunneyk