Issue Introduction I was asked if I knew any reason why SQL Agent would be using “a bunch” of memory…
Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read…
What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…
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…