Skip to content
Opinionated SQL
When no one else will tell you that you're holding it wrong...
  • Home
  • Who and Why
  • Send Me Your Thoughts

Tag: Threads

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

Demystifying Dumps: Non-Yielding Scheduler

August 23, 2021 Sean Gallardy 6 Comments

One of the most common items that will cause a memory dump in SQL Server is a non-yielding scheduler (generally…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Demystified, Dump, Dumps, Scheduling, SQL Server, SQLOS, Threads, WinDBG, Workers

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

  • Sean Gallardy on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Hannah Vernon on Trace Flag 2861 – The Trace Flag, The Myth, The Legend
  • Failure to Write to the Security Event Log – Curated SQL on Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8

Archives

  • 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