Performance Tuning with Query Store in SQL Server and Azure

Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator?

Did you recently migrate to Azure SQL Database, or stand up a new solution, and discover that you need to optimize performance to better use available resources and decrease costs?

Do you know that you have queries with inconsistent performance, but you're just not sure how to find them, or fix them, quickly?

Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the *real* problem with performance?

Query Store can help.

We’ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last 3 years. You'll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload.

This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you're a new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You'll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office.

Speakers

Wednesday 30 September 2020