Everyone wants their database to go faster, whether it's shaving hours off your ETL process, taking minutes off the runtime for reports, or trimming milliseconds off a critical OLTP query. Every database professional must know where to look and how to tune, whether you have one SQL environment or thousands.

In this full-day session, you'll learn how to take your performance tuning skills to the next level. The metrics SQL Server collects can be daunting. Identifying how to distill the data down to actionable information is an integral part of a DBA's job. After this session, you will understand what to look for, how to analyze the data, and you will know how to use an array of tools including query store, perfmon, and various scripts to get the critical performance information you need. Beyond tools and scripts, you'll become versed in the art and science of reading query plans to help you improve individual query performance. Finally, you'll learn about the newest performance enhancements within SQL Server 2022 and Azure SQL.

You'll leave this demo-filled session with the knowledge of which items to evaluate and how to resolve many issues that plague SQL Server performance.