22-25 April 2026 
Solving Hard To Crack Problems With Windows Performance Tool
2017TL; DR
You are hitting performance and scalability issues with the database engine, conventional wisdom and tools and getting you nowhere, where do you go ?, windows performance toolkit has the answers.
Session Details
You are hitting performance and scalability issues with the database engine, conventional wisdom and tools and getting you nowhere, where do you go ?. Windows performance toolkit has the answers and this session will allow you to unlock the secrets of the database engine, around things such as:
- CPU saturation, this will cover how the engine is structured, how to read call stacks and why windows performance toolkit is an order of magnitude more powerful than the debugger in this respect.
- any behaviour which is not documented, including latching and spin locking, the likes of the developer team, Bob Dorr and his ilk can infer a world of meaning from call stacks, this session will show how mere mortals can do this also.
- IO anomalies, is something in the path between your server and storage holding on to IOs or reordering them ?
- what is going off under the covers when you see strange wait activity, this will include a dive into the windows threading model.
- CPU saturation, this will cover how the engine is structured, how to read call stacks and why windows performance toolkit is an order of magnitude more powerful than the debugger in this respect.
- any behaviour which is not documented, including latching and spin locking, the likes of the developer team, Bob Dorr and his ilk can infer a world of meaning from call stacks, this session will show how mere mortals can do this also.
- IO anomalies, is something in the path between your server and storage holding on to IOs or reordering them ?
- what is going off under the covers when you see strange wait activity, this will include a dive into the windows threading model.
3 things you'll get out of this session
Speakers
Chris Adkin's previous sessions
Advanced Azure DevOps With Containers and Pipeline As Code
You are a developer and you want to leverage the 'Power' features in Azure DevOps via YAML pipeline as code, then this session is for you !
Probelm Solving Using The In-Memory Engine
The in-memory OLTP engine has been around since version 2014 of the database engine, do you need to be a SaaS provider processing billions of transactions a day to use this ?, the short answer is absolutely not and this session will show you why.
An Introduction To Column Store Indexes and Batch Mode
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
Superscaling SQL Server 2014 Parallel Insert
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
Column Store Index and Batch Mode Scalability Deep Dive
A deep dive into batch mode scalability with column store index and SQL 2014.
Scaling Out SSIS With Parallelism
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.