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

Presented by Thomas Kejser at SQLBits V
  • Downloads
    Slide deck available Slide Deck 2.3 MB
    Video available WMV Video 258 MB
  • SpeakerBIO
    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.
    http://sqlcat.com http://blog.kejser.org/
  • Video