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

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

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 I/O Affinity Configuration Setting – Please Stop

November 11, 2023 Sean Gallardy 1 Comment

I honestly have no idea how or why people tend to use this configuration option, if you know please drop…

Continue Reading →

Posted in: Configuration, SQL Server Filed under: configuration, IO, SQL Server, Threads, Windows

olved steries #5 – FCI Node Fails To Online After Patching

November 6, 2023 Sean Gallardy 1 Comment

The first video olved stery! In this one we look at an FCI node that will not come online after…

Continue Reading →

Posted in: CUs and GDRs, HA/DR, olved stery, SQL Server Filed under: Always On, FCI, HADR, olved steries, olved stery, Patching, SQL Server, Windows Server, WSFC

Automated SQL Dump Analysis – Beta!

October 26, 2023 Sean Gallardy 6 Comments

One of the things that is lacking in the community is for some simple dump analysis for SQL Server, well…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Dump, Dumps, Non-Yielding, SQL 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

PSA: Uptick in CrowdStrike Issues with SQL Server (Non-Yielding Scheduler)

August 19, 2023 Sean Gallardy 1 Comment

I would say I’m surprised but… ahem… I’m not. My own snarkyness aside, I’m not sure what updates have or…

Continue Reading →

Posted in: NotASQLServerProblem, Security, SQL Server Filed under: Debugging, Drivers, Dump, Heavy Sigh, Non-Yielding, NotReallyASQLProblem, PSA, SQL Server

olved steries #4 – SQL Won’t Shut Down!

July 8, 2023 Sean Gallardy

Issue Introduction I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to…

Continue Reading →

Posted in: olved stery, SQL Server Filed under: Debugging, Dump, Monitoring, olved steries, olved stery, service broker, SQL Server, WinDBG

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

olved steries #3 – SQL Agent Eating Memory

May 21, 2023 Sean Gallardy 1 Comment

Issue Introduction I was asked if I knew any reason why SQL Agent would be using “a bunch” of memory…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, SQL Server Filed under: Debugging, Dump, NotReallyASQLProblem, ODBC, olved steries, olved stery, SQL Server, SQL2022, WinDBG

Post navigation

Page 1 of 5
1 2 … 5 Next →

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