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