What do SQL dump files do?

What are dump files used for?

You can use a dump file from a customer's machine when you can't reproduce a crash or unresponsive program on your own machine. Testers also create dumps to save crash or unresponsive program data to use for more testing. The Visual Studio debugger can save dump files for managed or native code.

What causes SQL dump files?

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.

What does it mean to dump a file?

A dump file is a snapshot of an application at the point in time the dump is taken. It shows what was executing, what modules are loaded, and if saved with heap, contains a snapshot of what was in the application's memory at that point in time.

What do I do with .SQL file?

How to open an SQL file. SQL files can be read by any SQL-compatible database program, such as MySQL and Richardson RazorSQL. You can also open and edit SQL files in various source code editors, such as gVim, Bare Bones BBEdit, and MacroMates TextMate.