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

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

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

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

Error 35217 And Availability Groups /SMH

May 9, 2020 Sean Gallardy 1 Comment

Well That Escalated Quickly… Error 35217 translates to, “The thread pool for AlwaysOn Availability Groups was unable to start a…

Continue Reading →

Posted in: HA/DR, SQL Server Filed under: HADR, Infrastructure, Monitoring, Performance, SQL Server, Threads, virtualization

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