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

Presenter: Maciej Pilecki

Session Details:

This session explores a 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 for 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 the need to understand its internals.

This session touches on all aspects of SQLOS: the basics of its architecture, through thread scheduling, memory management and Resource Governor; Extended Events; and advanced SQL Server configuration. You will become familiar with 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. Learn tips and tricks that can make a big difference in performance of high-end servers under heavy load.
 

About the Speaker:

Maciej Pilecki is a SQL Server MVP, Microsoft Certified Master in SQL Server 2008, Microsoft Certified Trainer, and Senior Consultant with Project Botticelli. He has many years of international experience in SQL Server database development, optimization, and troubleshooting. He spends most of his time travelling around the world either advising customers on how to improve performance and reliability of their databases or sharing lessons learned with conference and user group audiences worldwide, where he is a popular and highly rated speaker. His favorite topics are the internals of the SQL Server database engine including SQLOS, Storage Engine, and Query Optimizer and Performance Tuning.

Maciej likes skiing with his son and trekking in the mountains in his spare time.