Designing I/O systems for SQL Server
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
Thomas has been working with SQL Server since version 6.5 and performance tuned cubes since OLAP Server 7.0. He has worked on some of the largest cubes in the world. Performing fast loading of warehousing and removing every bottleneck is one of Thomas specialties. He holds a master degree in computer science and has 10+ years of experience with developer coaching and scalable architectures on both OLTP and OLAP systems.
- Session Files Explorer
The network name cannot be found.