Skip to content
Tracy Boggiano's Blog

Tracy Boggiano's Blog

Musing on more than data, trying to make a difference somewhere…

  • Home
  • About Me
  • Presentations
  • Events
  • DEI Virtual Group
  • Speaking Mentors
  • TriPass
  • WITspiration
  • Mental Health Resources
  • DBA Resources

Month: June 2018

  • Home
  • 2018
  • June
Miscellaneous

Query Store Error State

June 26, 2018June 17, 2018By Tracy Boggiano

We recently discovered some of our databases in an Error State for SQL Server.  Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup.  They are working on a bug fix for it.  For now, it suggested you set up something that checks your databases to see

Performance

Query Store Usage and Automatic Plan Correction Usage

June 17, 2018February 14, 2019By Tracy Boggiano

Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following: Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store. Erin Stellato blogged about it in this article Why Aren’t You Using Query Store?

Recent Posts

  • Looking Back at 2025: Volunteering Is My Way of Life January 9, 2026
  • Living with Chronic Suicidal Thoughts: A Personal Reflection November 20, 2024
  • MVP No more, But It’s OK July 12, 2024
  • Presenting at PASS Summit 2023 – Atomic Habits July 26, 2023
  • Twenty Years as a Guardian ad Litem June 26, 2023

Categories

  • Automation (24)
  • Exam Prep (9)
  • High Availability/Disaster Recovery (5)
  • Mental Health (14)
  • Miscellaneous (51)
  • Performance (14)
  • PowerShell (7)
  • Scripts (23)
  • Security (8)
  • SQLskills (1)
  • T-SQL Tuesday (32)
  • Training (4)
All Rights Reserved 2022.
Proudly powered by WordPress | Theme: Saya by Candid Themes.