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: Performance

CrowdStrikes Again!

August 18, 2025 Sean Gallardy 1 Comment

It feels like only yesterday I was complaining about Sentinel One trying to take the crown for shittiest security software.…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Antivirus, Drivers, Heavy Sigh, NotReallyASQLProblem, PSA, Security, SQL Server, Weird Errors

Sentinel One Is Breaking SQL And Your Cluster

July 10, 2025 Sean Gallardy 7 Comments

I have a long history shitting on CrowdStrike – and well, with their past it’s pretty warranted – but antivirus…

Continue Reading →

Posted in: Dumps, General Info, HA/DR, NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Availability Groups, Drivers, Dump, HADR, Heavy Sigh, NotReallyASQLProblem, Performance, PSA, Security, SQL Server, Windows, Windows Server

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

olved steries #2 – Slow Restore

August 8, 2021 Sean Gallardy 1 Comment

Issue Introduction In this olved stery the problem comes as a slow database restore. That’s what I was given, that’s…

Continue Reading →

Posted in: NotASQLServerProblem, olved stery, Performance, SQL Server Filed under: Backups, network latency, olved stery, Performance, restores, SQL Server

Possible configuration error: 1000000 IO requests allocated

May 23, 2021 Sean Gallardy 1 Comment

You’ve won! If, somehow, you’ve managed to see this error in your errorlog then congratulations, you’ve won an instance of…

Continue Reading →

Posted in: Performance, SQL Server, Storage Filed under: Asynchronous IO, Performance, SQL Server, Storage, Weird Errors

olved steries #1 – SQL FCI Failovers

April 29, 2021 Sean Gallardy 7 Comments

Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how…

Continue Reading →

Posted in: NotASQLServerProblem, Performance, Security, SQL Server Filed under: Always On, Cheater Cheater, Drivers, FCI, GottaLoveSecurity, HADR, IRPs, NotReallyASQLProblem, olved steries, Security, SQL Server, Windows IO

Availability Group Long Failover Times

April 18, 2021 Sean Gallardy 1 Comment

One of the most common issues I look at from day to day is some variation of the question. “Why…

Continue Reading →

Posted in: CUs and GDRs, HA/DR, Performance, SQL Server Filed under: Antivirus, Availability Groups, Drivers, Failover, HADR, Patching, Performance, SQL Server

Undo of Redo – Reverting (and Initializing)

April 12, 2021 Sean Gallardy 1 Comment

Departure Hopefully, you’re not finding this entry because you’re scouring the web for what reverting means while your production server…

Continue Reading →

Posted in: HA/DR, Performance, SQL Server Filed under: Always On, Availability Groups, Recovery, SQL Server

Do You Really Have A HA Issue?

March 15, 2021 Sean Gallardy

I tend to be involved in many HA related issues, as is the nature of my current work agreement. The…

Continue Reading →

Posted in: HA/DR, Performance, SQL Server Filed under: HADR, Performance, Planning, SQL Server

Subscribe via RSS!

Recent Comments

  • Hannah on CrowdStrikes Again!
  • Suresh Kurapati on Sentinel One Is Breaking SQL And Your Cluster
  • Sean Gallardy on Sentinel One Is Breaking SQL And Your Cluster

Archives

  • November 2025
  • August 2025
  • July 2025
  • 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