Skip to content
Opinionated SQL
When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why
  • Contact Me
  • SQL Error Code Search
  • Automated SQL Server Dump Analysis

Category: DMVs

Read Scale Availability Group – Failed to update Replica status due to exception 35222.

November 21, 2023 Sean Gallardy Leave a comment

Read Scale Availability Groups can be pretty useful in the right places and for the right things and were a…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: Always On, Availability Groups, benign, HADR, read-scale, SQL Server, Weird Errors, WSFC

model_msdbdata and log, model_replicatedmaster and log – What are they?

July 3, 2023 Sean Gallardy 4 Comments

There was a question that came up on the MCM mailing list about what are these files: model_msdbdata.mdf, model_msdblog.ldf, model_replicatedmaster.mdf,…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: Availability Groups, general, HADR, SQL Server, SQL2022

What Are PREEMPTIVE Waits And How Can They Kill Performance

November 27, 2022 Sean Gallardy 3 Comments

Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read…

Continue Reading →

Posted in: DMVs, Performance, SQL Server, Waits Filed under: Debugging, Demystified, Monitoring, Non-Yielding, Performance, SQL Server, Threads, Wait Types, WinDBG, Windows

Stop using Sys.dm_hadr_cluster_members for “quorum” information

May 9, 2020 Sean Gallardy 1 Comment

Update 5/24/2022: I’ve updated the DMV to reflect the various node and witness dynamic settings with a new column at…

Continue Reading →

Posted in: DMVs, HA/DR, SQL Server Filed under: DMV, DoesntWorkLikeYoudThink, HADR, Monitoring, SQL Server, WSFC

Subscribe via RSS!

Recent Comments

  • gotqn on SQL Server I/O Affinity Configuration Setting – Please Stop
  • Sean Gallardy on Storage Testing – Cheap and Fast?!
  • Hannah Vernon on Storage Testing – Cheap and Fast?!

Archives

  • November 2023
  • October 2023
  • August 2023
  • July 2023
  • May 2023
  • April 2023
  • March 2023
  • January 2023
  • November 2022
  • October 2022
  • May 2022
  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • September 2020
  • August 2020
  • June 2020
  • May 2020
  • January 2020
  • September 2019
  • June 2019
  • May 2019
Copyright © 2019 Opinionated SQL