Thomas specializes in high scale performance tuning and data modeling and has built some of the largest SQL Server database in the world.
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