Designing I/O systems for SQL Server

2009

TL; DR

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.

Session Details

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

3 things you'll get out of this session

Speaker

Thomas Kejser's previous sessions

BigData vs. Data Warehousing - 2012

DW Design With The Product Team - 2012

Relational Modeling for Extreme DW scale - 2011

Finding the Limits - 2011

Lessons Learned from 128 Core OLTP Testing - 2010

Designing and Tuning high speed data loading - 2010

Designing High Scale OLTP systems - 2010

Designing I/O systems for SQL Server - 2009

Introducing Project Madison - 2009