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

Thomas Kejser's previous sessions

BigData vs. Data Warehousing

: We are looking at the dawn of a new workload: BigData. In this session I will talk about what BigData is, and which BigData technologies Microsoft are working on.

DW Design With The Product Team

This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.

Relational Modeling for Extreme DW scale

This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.

Finding the Limits

In this session, I will take simple SQL statements, the stuff you write every day, and bump up the scale until things start breaking

Designing and Tuning high speed data loading

My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server so come here my talk on the options you have.

Designing High Scale OLTP systems

My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server. This talk focuses on lessons learned when using high end hardware and stressing it.