Index Maintenance and Performance (Dear SQL DBA Episode 38)

on April 13, 2017

They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index maintenance have harmed performance?

In this 29 minute episode…

  • 00:50 Thinking about plan freezing in Query Store and multi-team process
  • 03:15 This week’s question about index maintenance and query performance

Subscribe to my YouTube channel, or check out the audio podcast to listen anywhere, anytime. Links from this episode are in this post below the video and in the YouTube description.

Free, configurable index maintenance options:

You may enjoy reading…