WMV files are unsupported

Click here to open the file

SQLBits 2009

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

Speaker

Thomas specializes in high scale performance tuning and data modeling and has built some of the largest SQL Server database in the world.

Thomas Kejser's Sessions

BigData vs. Data Warehousing

BigData vs. Data Warehousing

BigData vs. Data Warehousing

BigData vs. Data Warehousing

DW Design With The Product Team

DW Design With The Product Team

DW Design With The Product Team

DW Design With The Product Team

Relational Modeling for Extreme DW scale

Relational Modeling for Extreme DW scale

Relational Modeling for Extreme DW scale

Relational Modeling for Extreme DW scale

Finding the Limits

Finding the Limits

Finding the Limits

Finding the Limits

Lessons Learned from 128 Core OLTP Testing

Designing and Tuning high speed data loading

Designing and Tuning high speed data loading

Designing and Tuning high speed data loading

Designing and Tuning high speed data loading

Designing and Tuning high speed data loading

Designing High Scale OLTP systems

Designing High Scale OLTP systems

Designing High Scale OLTP systems

Designing High Scale OLTP systems

Designing I/O systems for SQL Server

Introducing Project Madison