WMV files are unsupported

Click here to open the file

SQLBits 2009

Designing I/O systems for SQL Server

In this session we will take a deeper look at how SQL Server uses I/O and how you can design the I/O system to meet the requirements of your applications.
This session builds on the theory from "An introduction to I/O subsystems". We will take a closer look at tuning I/O for both SQL Server and Analysis Services. The following subjects will be covered:
  • SQL Server I/O patterns
  • Measuring and troubleshooting I/O on SQL Server
  • Data Warehouse specific Tuning
  • Fast Trac
  • Analysis Services Tuning
  • OLTP Specific Tuinng
  • Capacity Planning and Specification
  • High Availability and SAN