SQL Server 2019 Many No Longer Capture Mini-Dump (SQLDump####.mdmp)


Moved from: bobsql.com

 

I was looking at a SQL Server which had generated ten(10) SQLDump####.txt files but only a single(1) SQLDump####.mdmp file.  We introduced a new feature in SQL Server 2019 to save disk space for mini/crash dumps which can skip the suspension and capture for identical dump signatures, saving disk space and reducing the impact on the SQL Server instance.

 

Each time the SQL Server instance is started a hash table is created to track crash dump signatures. The first time a crash dump signature is encountered a SQLDump####.mdmp is created and the signature is stored in