Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
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.
Links and further reading from the show this week…
Free, configurable index maintenance options:
- https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
- http://minionware.net/reindex
You may enjoy reading…
- An interesting post on Trace Flag 2389 (ascending statistics flag) and the new cardinality estimator, by Erin Stellato
- The documentation on Trace Flag 2371 (changing automatic stats update behavior)
- My post on Updating Statistics in SQL Server: Maintenance Questions & Answers