Skip to content
Query Store and Automatic Tuning in SQL 2017 with Erin Stellato episode artwork

Feb 7, 2018 33 min

Query Store and Automatic Tuning in SQL 2017 with Erin Stellato

from RunAs Radio Hosted by Richard Campbell

SQL Server keeps getting smarter! Richard talks to Erin Stellato about Query Store and Automatic Tuning. First introduced in SQL Azure, these features showed up in SQL Server 2016 and improved substantially in 2017. Erin describes Query Store as a kind of black box for databases, similar to an aircraft, but you don't need to wait for a crash to value the data stored in it. Query Store is a real-time record of the queries happening in your database, along with the query plan and what caused the query to wait. This leads to a ton of tuning opportunities, including automated tuning, where SQL Server will recommend indexes and other performance features for itself!

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Query Store and Automatic Tuning in SQL 2017 with Erin Stellato

0:00 33:37

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of RunAs Radio?

This episode is 33 minutes long.

When was this RunAs Radio episode published?

This episode was published on February 7, 2018.

Can I download this RunAs Radio episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.