Session room

The Agenda

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

Advanced Techniques For Super Scaling SQL Server

Description

You are a DBA or developer working on applications with mission critical performance requirements so exacting that a level 400~500 understanding of the database engine is required in order to extract every last ounce of performance from the database engine. This session aims to deliver on this by providing a 360 degree via of what what the database engine is doing and how to crack 'Hard' problems involving undocumented waits and spinlock activity that the standard out of the box SQL Server tools provide little or no insight into. Techniques will be covered for performing deep analysis of CPU saturation scenarios, wait analysis at thread level, the trouble shooting bad device drivers, networking and IO down to the full IO path from the database engine right through to device driver level, all via windows performance toolkit.

Learning Objectives

Previous Experience

Tech Covered

performance, DBA