Forum Discussion
SQL server 2019 log file take up a lot of space (dmp file)
It is found that disk D has 100g less space these days. It turns out that the DMP file in the path (\ mssql15. MSSqlServer \ MSSQL \ log \ POLYBASE \ dump \) under the SQL server2019 directory takes up a lot of space. Each DMP has 600MB, and this file will be generated by itself every 40 minutes or so and will not disappear by itself. I have found many ways to prevent him from generating or automatically deleting the previous files after reaching a certain number. I want to ask you if there is any way.
I found a solution. Although I don't understand it very well, it works very well.
Enter Win + R to run services msc，
Find the service in the picture in the service and prohibit them.
In this way, the dump folder will not generate DMP files by itself.
As shown in the figure, you can disable the two SQL POLYBASE services
3 Replies
I found a solution. Although I don't understand it very well, it works very well.
Enter Win + R to run services msc，
Find the service in the picture in the service and prohibit them.
In this way, the dump folder will not generate DMP files by itself.
As shown in the figure, you can disable the two SQL POLYBASE services
- The original DMP file can also be deleted according to your choice. At present, there is no impact after I delete it. This scheme is for reference only
AZAZAZAZ , DMP are dump file, which are created on failure / system crash.
They contain detail informations about the crash, so MS Support can analyse the cause.
If you are on latest CU 15 for SQL Server 2019, you could contact MS Support to get help.
Microsoft SQL Server Versions List (sqlserverbuilds.blogspot.com)
Olaf
