Issue Introduction Someone asked if I’ve ever had a CU install where you run it and it goes through the extraction process, then right as it hits 100% just exits and nothing happens. Well, that’s pretty weird, and no, I hadn’t. I was, however, intrigued! Since I love my readers, I made a repro of […]
This issue was a fun one, brought to me due to a single replica in an availability group constantly having an issue where it seemed that SQL Server just stopped processing certain requests. If you’re reading this and thinking to yourself, “Just one replica in the topology? What’s different with that one replica?” then give […]
I meant to write this almost a year ago, but then I was asked to take a look at high cluster service privileged time usage and realized I had forgotten! I guess better late than never? If you’re using WSFC integrated AGs (cluster_type = WSFC) then the cluster database is the location in which availability […]
I have a long history shitting on CrowdStrike – and well, with their past it’s pretty warranted – but antivirus software is general does bother the hell out of me. You’re essentially installing something that interrogates everything on your system and injects itself everywhere hoping it stops a known issue but generally ends up causing […]
I’ve been playing around with some different NVMe drives lately, looking at different performance characteristics and when I saw the output of some initial testing it made me want to write a quick post. Today, cloud is still the hotness (well, if you get past everyone saying AI like they said ML a few years […]
The first video olved stery! In this one we look at an FCI node that will not come online after patching. Issue Introduction This was an issue I almost forgot about, during the patching of an FCI to a new CU, the inactive server patches without an issue – all is well. Upon attempting a […]
It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance – that’s awesome, even in heavily regulated industries which require these things, no one ever looks at them. Having been part of audits for years (and thankfully not involved for almost the last decade) I […]
Hey Dispatch, We Have a Code 8 If you’ve been following with the series of demystifying dumps then you’re probably thinking or have thought something along the lines of, “All of these issues seem to be around stalled or non-yielding things…” and you’d be correct. If you revisit the non-yielding scheduler dump post, I explain […]
What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO. Great, that pretty much tells you nothing. SQL Server uses IO Completion Ports not for disk-based IO but for general network IO when it comes into SQL Server for TDS level items. This means it’s […]
Access Violations (AV) are another common error that will cause SQL Server to take a memory dump. These can occur for a variety of reasons, and unlike the last one (Non-Yielding Scheduler) it’s quite the task, especially given public symbols don’t have structure data and offsets. Citations and Fines Access violations occur because a region […]
