Prevent SQL Server Dump Generation in Hot Cases: Common Ways & Scenarios

Summary: This article discusses common way to prevent SQL dump from being generated in different exception scenarios. This workaround serves for hot scenario where you need to immediately stop the PRODUCTION outage caused by dump generation. You should already have a dump file feasible for RCA investigation purpose. You should also have confirmed that the exactly same exception continue triggering dump which has the same call stack for the offended thread. 


In a hot PRODUCTION environment , especially in SQL Clustered setting (SQL AG or FCI), to quickly safe your production from outage caused by dump generation process, we