Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

A Day Inside SQL Server

Description

Do you want to know more about the internal workings of the SQL Server Engine? Do you have a desire to have your brain melted in a single day? This session may be for you. This training day event will cover the internal workings of SQL OS, SQL Server Memory, and SQL I/O: three of the most important fundamental components of the SQL Server Engine. This session is focused on the up to date internals of SQL Server 2012 and SQL Server 2014 but we will also point out differences where appropriate from prior releases.

Some of the topics included in this session but not limited to are:

  • Thread Scheduling
  • Resource Management
  • Windows API integration
  • Memory Management
  • Resource Governor
  • The Lifecycle of I/O
  • Tempdb and I/O
  • Cloud Hybrid I/O Scenarios

This session will include plenty of demos and as with any "Inside" session a healthy use of the Windows Debugger with SQL Server. This a very deep advanced session but understanding these internals can help you better prepare for deployment, management, and monitoring of your SQL Server.

Learning Objectives

Previous Experience

Tech Covered

performance