MasterClass: Microsoft SQL Server Performance Tuning Bootcamp

This course is intended for SQL Server administrators who are responsible for the performance of their database servers and installations and SQL Server developers who are responsible for developing SQL Server queries and stored procedures.

Before attending this course, it is recommended that students have experience with SQL Server and SQL Server Administration, understanding of database concepts and Transact-SQL programming. Knowledge of SQL Server Performance Tuning concepts is also recommended.

Module 1 - Introduction to SQL Server architecture

Module 2 - Introduction to SQL Server performance tuning tools

Module 3 - Introduction to SQL Server CPU

Module 4 - SQL Server configurations affecting CPU usage

Module 5 - Performance monitoring and tuning SQL Server CPU

Module 6 - Introduction of SQL Server memory architecture

Module 7 - SQL Server configurations affecting memory usage

Module 8 - Performance monitoring and tuning SQL Server memory

Module 9 - SQL Server concurrency

Module 10 - Monitoring SQL Server concurrency

Module 11 - SQL Server Indexing and index maintenance

Module 12 - Introduction to the Query Processor

Module 13 - Understanding SQL Server Execution Plans

Module 14 - Review of common query coding which causes poor performance

Module 15 - Plan Guides, query hints, UDFs, and Computed Columns

Module 16 - Introduction to disk subsystem terminology and architecture

Module 17 - Disk subsystem RAID levels

Module 18 - SQL Server files and filegroups

Module 19 - Performance monitoring and tuning the SQL Server disk subsystem

Module 20 - Working with SQL Server transaction log

Module 21 - Working with SQL Server tempdb

Module 22 - SQL Server partitioning (database and table)

Module 23 - SQL Server database maintenance

Herbert Albert is an MCSE, MCTS, MCITP, MCDBA, and MCT in SQL Server. He is a SQL Server trainer, consultant and Managing Director of the Central Europe Subsidiary. His knowledge covers a wide spectrum of Microsoft Technologies and Network Architecture, although his focus is mainly in SQL Server. He is co-author of "SQL Server 2008 Upgrade Technical Reference Guide”  and “SQL Server 2005 Step-by-Step Applied Techniques”, Microsoft Press 2006. He is a featured speaker on the SQLU Summit 2011.