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

Tag: Availability Groups

Contained Availability Group Creation Access Violations

December 4, 2023 Sean Gallardy 1 Comment

Contained Availability Groups are the most recent update to the Availability Groups feature, and a great update at that! They…

Continue Reading →

Posted in: Configuration, CUs and GDRs, HA/DR, Logins, Security, SQL Server Filed under: Access Violation, Always On, AV, Availability Groups, Contained AGs, HADR, Security, SQL Server, SQL2022

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

November 21, 2023 Sean Gallardy

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

Storage Testing – Cheap and Fast?!

November 18, 2023 Sean Gallardy 2 Comments

I’ve been playing around with some different NVMe drives lately, looking at different performance characteristics and when I saw the…

Continue Reading →

Posted in: Hardware, Storage Filed under: Always On, automatic Seeding, Availability Groups, HADR, hardware, nvme, SQL Server, ssd, Storage, Windows Server

SQL Server 2022, Distributed Availability Groups, and FileStream

August 27, 2023 Sean Gallardy 2 Comments

I don’t often find many people using FileStream in their databases (which isn’t a bad or good thing, in my…

Continue Reading →

Posted in: HA/DR, SQL Server, Trace Flags Filed under: Always On, Availability Groups, Distributed Availability Groups, HADR, SQL Server, trace flag

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

Non-WSFC Dumping Woes – Assert in ucsconnectionsend.cpp

March 29, 2023 Sean Gallardy 5 Comments

Setup If you’re using availability groups with read-scale or linux (cluster type = None/External), you might want to watch the…

Continue Reading →

Posted in: Dumps, HA/DR, SQL Server Filed under: Always On, Availability Groups, Dump, Dumps, HADR, linux, read-scale, SQL Server, WSFC

Cluster Resource DLL Connectivity In Availability Groups

March 11, 2023 Sean Gallardy

I was recently asked a question, while fixing a cluster connectivity issue, about how the cluster resource dll knows on…

Continue Reading →

Posted in: HA/DR, Security, SQL Server Filed under: Always On, Availability Groups, HADR, NotReallyASQLProblem, ODBC, Security, SNAC, SQL Native Client, SQL Server, WSFC

Want To Remove SNAC 2012? Upgrade To SQL 2022

March 5, 2023 Sean Gallardy 1 Comment

I see many questions, and have been on the receiving end of many myself, about out of support items and…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, Drivers, FCI, HADR, ODBC, SNAC, SQL Native Client, SQL2022, SQLNCLI

SQL Server 2022 – Contained AGs – Overview

May 24, 2022 Sean Gallardy 1 Comment

You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: Availability Groups, Contained AGs, SQL Server, SQL2022

Understanding the HADR_SYNC_COMMIT wait

September 22, 2021 Sean Gallardy 2 Comments

Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…

Continue Reading →

Posted in: HA/DR, SQL Server, Waits Filed under: AGs, Always On, Availability Groups, HADR, HADR_SYNC_COMMIT, Monitoring, SQL Server, Synchronous Commit, Threads, Wait Types, Waits

Post navigation

Page 1 of 2
1 2 Next →

Subscribe via RSS!

Recent Comments

  • George Walkey on What Happened To Stack Exchange?
  • Sean Gallardy on What Happened To Stack Exchange?
  • Jankow on What Happened To Stack Exchange?

Archives

  • January 2025
  • November 2024
  • June 2024
  • December 2023
  • 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