Secrets of the SQLOS - Leveraging Microsoft SQL Server Internal Operating System for Improved Scalability and Performance

Highest scoring pre-conference session at TechEd North America 2010

Delivered by an expert on the subject, this seminar will make you familiar with one of the most mysterious component of Microsoft SQL Server its own internal built-in operating system, or SQLOS.

SQLOS is little known and even less documented. It provides operating-system-like services to other components running within the engine and forms a foundation of SQL Server scalability, reliability and performance. As the scalability requirements increase and hardware becomes more and more powerful, SQLOS role grows more and more important and so does our need to understand its internals.

During the course of the day, we will cover all aspects of SQLOS from the basics of its architecture, through thread scheduling, memory management and Resource Governor, to troubleshooting, Extended Events and advanced SQL Server configuration. Through a series of lectures and demonstrations, you will become familiar with all aspects of its operations and how it enables SQL Server to take advantage of modern, powerful hardware architectures with many CPUs and vast amounts of memory available. You will also learn how to diagnose and troubleshoot advanced performance issues on such servers, including tips and tricks that can make a big difference in performance of high-end servers under heavy load.

This seminar is addressed to experienced Database Administrators and Database Developers, building and operating high-end, mission-critical database applications on Microsoft SQL Server 2005, 2008 and 2008 R2. Experience in working with SQL Server either as a DBA or Database Developer is a prerequisite.