SESSION Details

Automagic Tuning in SQL Server

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:

• Had a query suddenly slow down at 2 AM when you were on call?
• Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt?
• Had the optimizer choose the wrong type of join and send your query off to never finish?

Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

feedback link: https://sqlb.it/?7050

Starts: 13:40 10th Mar 2022
Ends: 14:00 10th Mar 2022

Q&As

Short Description
- Understand the automatic performance changes in Azure SQL and SQL Server

Slidedeck Link

Dantoni_Automagic_Tuning_Bits_2022.pptx

Speakers

Joey D'Antoni

Tags

Platform AgnosticFuture DBAOperational DatabasesOptimisingAzure SQL DatabaseDatabase EngineQuery StoreIntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.