Course Overview

In the end, nearly every enterprise business system talks to a database, and if that database is slow, the ramifications can be huge across all applications. A speedy database is critical.

Small code is fast code and fast code is good code. While we no longer have to worry about SQL Server-level tuning, the black box of the SQL Server query processor makes things quite a bit interesting for performance tuning. This intense class is all about performance tuning T-SQL code to help teach developers how to think and do “fast.”

The course begins with a discussion about performance tuning and the ramifications of SQL internals and query patterns on performance. The second part of the class then covers key performance issues of everyday things in SQL, so developers understand the ramifications of all sorts of interesting SQL constructs and can avoid performance pitfalls. The main part of the class is spent learning analyze performance for real world applications. While the focus is on using the SQL Server performance tools, discussions on various other related tools are included as well.

Key Learning Areas

Too many developers treat SQL Server as a black box and hope for the best when they use it. It doesn’t have to be that way, and this class will show you how to approach tuning and tweaking SQL Server until the database side screams.

  • See the five layers of performance
  • Learn the SQL Server engine and query internals
  • Conquer the SQL Server profiler to solve the hardest T-SQL performance issues

Course Outline

  • The five layers of performance
  • SQL Server engine internals
  • SQL Server query processing architecture
  • How to time small operations
  • Comparing and contrasting everyday SQL constructs
  • Resource usage Tools
  • 3rd party tools

Who Benefits

Anyone who works with the Microsoft SQL Server database and is interested in getting the utmost performance out of their SQL queries. The focus for this class is obviously T-SQL code, so it will not discuss application code performance, network performance, or general machine performance.

Prerequisites

The expected audience for this course is developers and testers working with T-SQL code.