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
Slide Deck 2.3 MB , WMV Video 258 MB