What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…
Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…
Access Violations (AV) are another common error that will cause SQL Server to take a memory dump. These can occur…
One of the most common items that will cause a memory dump in SQL Server is a non-yielding scheduler (generally…
Issue Introduction In this olved stery the problem comes as a slow database restore. That’s what I was given, that’s…
You’ve won! If, somehow, you’ve managed to see this error in your errorlog then congratulations, you’ve won an instance of…
Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how…
One of the most common issues I look at from day to day is some variation of the question. “Why…
Departure Hopefully, you’re not finding this entry because you’re scouring the web for what reverting means while your production server…
I tend to be involved in many HA related issues, as is the nature of my current work agreement. The…