Using Query Store Hints to Stabilize Query Performance by Erin Stellato

As a data professional you often get pulled in to troubleshoot a drop in performance, and it can be stressful. Once you determine the problem, people want you to fix it... immediately. But what if you don't have direct code access? Or even if you do, you have to go through a change control process which can take hours or days, and you don't know when performance will tank again.

Did you know there are built-in features that can not only help you find problematic queries, but can also help you manage query performance *without* changing the schema or the code? Whether you have SQL Server on-premises, in the cloud on a VM, or you use Azure SQL Database, this session will step through new functionality, including Query Store Hints, which leverages Query Store to help you stabilize query performance immediately.

Query Store and Parameterization Problems

Query Store and hints: More Powerful than ever

Managing Query Store Hints

Let's connect
============

[DennesTorres]

Reference links offered during the conference:

MSC and SQL Server 2022

Synapse Link on Data Exposed

Ledger and Lenovo

Synapse Link for SQL

Failover to Managed Instances

SQL Ledger

Bob Ward Github with many samples about IQP and much more