What is crash dump file in SQL Server?

Question

A SQL Server 'crash' occurs - either an A/V, assert or some other uncaught code error. In this case the file is a memory dump, the size and contents of which are dependent on the problem that occured. You're signed up for Watson error reporting and DBCC CHECKDB found corruptions in a database. 22 июн. 2009 г.

Can I delete SQL crash dump files?

If your log folder has several dumps for a few years ago and then no dumps for several months, then a few recent dumps, you can safely delete the old dumps.

What are crash dump files?

A dump file (or crash dump) is what is created when a process contents are written to a file. This can happen automatically if the application has been set up to create them upon an exception or if the exception bubbles up to the underlying operating system.

What is a SQL Server dump file?

Summary. The Sqldumper.exe utility is included with Microsoft SQL Server. It generates memory dumps of SQL Server and of related processes for debugging purposes. This article describes how to use the Sqldumper.exe utility to generate a dump file for Watson error reporting or for debugging tasks.

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.

Expert · Answer