I am often asked about all kinds of various errors, of course with absolutely no context. I also get asked what error X is or means or says… I don’t remember that stuff off the top of my head. The thing is, you kind of need SQL Server to go look it up and there […]
The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often. Generally, my answer is that I don’t for two main reasons… the first being that none of them are actual vulnerabilities, and the second being that none of them are particularly new but merely items […]
You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could not be part of the AG. This is how mirroring worked, and AGs were an evolution of mirroring, solving many of the problems that mirroring had (although mirroring solved many of the problems log shipping […]
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 […]
Many DBAs haven’t had the experience of using database mirroring, since it was deprecated in 2012 when availability groups were released, and so there’s a lot of history that ends up being lost. We’re going to dive into some of that history and how it could affect your availability group! Update: You can get rid […]
I’ve been writing some technical, some troubleshooting, but all items that come up often enough without a resource that when I see it, I’ll write about it. That’s fun. What I want to know, though, is what items are you all wanting to know about or otherwise are a mystery? Feel free to send me […]
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 […]
Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL Server”, then I realized maybe this isn’t the case… So, I pondered over this question, “is it truly misunderstood?” and came to the (possibly incorrect) realization that it is quite accurate in the general SQL […]
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 […]
