What is SQL dump?

What causes a SQL dump?

When there is something “unexpected”, SQL Server kills the SPID and generates a dump. There are situations where SQL threads are not yielding (“Non-yielding Scheduler”, “Non-yielding IOCP Listener” or “Non-yielding Resource Monitor”) and there would be data needed to diagnose the problem later, so a dump is generated.

Where is SQL dump file?

By default, Dump directory is 'C:\Microsoft SQL Server\MSSQL10_50. MSSQLSERVER\MSSQL\LOG\' in Windows system.

What is dump in database?

A database dump is a major output of data that can help users to either back up or duplicate a database. This can be considered part of a the more general term data dump, which involves revealing a set of stored data from a given technology.

Can I delete SQL dump files?

You should analyse and determine the cause of the Stack dumps, If you have support from microsoft, you can consult them and of course you can always delete them, they are nothing but memory dumps, may be generated because of memory issue, access violations, DB courruption, etc.