Better Performance through Parallelism [AD-499-P]

Speaker: Adam Machanic

Duration: full day

Track: Application & Database Development

Today's server hardware ships with a truly massive amount of CPU power. And while SQL Server is designed to automatically and seamlessly take advantage of available processing resources, there are a number of options, settings, and patterns that can be exploited to optimize parallel processing of your data. 

This full-day pre-conference session starts with an overview of CPU scheduler internals from the perspective of both Windows and the SQL Server Operating System (SQLOS). Next, you will learn about intra-query parallelism, the method that SQL Server uses to break up large tasks into many smaller pieces, so that each piece can be processed simultaneously. You will come to understand how to read parallel query plans and how to interpret parallel wait statistics, as well as best practices for the various parallelism settings within SQL Server. Finally, you will be introduced to techniques for exploiting parallelism at the query level: patterns that can help the optimizer do a better job of parallelizing your query. 

After attending this pre-conference session, you will be in full control of your CPUs and be able to compel your server to use every clock tick to your end users' advantage.

Accompanying Material

No material found.


cage-aids
cage-aids
cage-aids
cage-aids