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

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

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

Demystifying Dumps: Stalled Dispatcher

December 1, 2021 Sean Gallardy 1 Comment

Hey Dispatch, We Have a Code 8 If you’ve been following with the series of demystifying dumps then you’re probably…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Demystified, Dump, Dumps, Non-Yielding, SQL Server, stalled, stalled dispatcher, Windows, Windows Server

Demystifying Dumps: Non-Yielding (Stalled) IOCP

November 18, 2021 Sean Gallardy 2 Comments

What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Debugging, Demystified, Dump, Dumps, IOCP, Non-Yielding, SQL Server, Windows, Windows Server

Demystifying Dumps: Access Violation

August 29, 2021 Sean Gallardy 1 Comment

Access Violations (AV) are another common error that will cause SQL Server to take a memory dump. These can occur…

Continue Reading →

Posted in: Dumps, SQL Server Filed under: Access Violation, Debugging, Demystified, Dump, Dumps, SQL Server, Windows, Windows Server

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

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