patternsqlMinor
Why is Microsoft SQL Server creating a ton of dump files?
Viewed 0 times
dumpwhysqlcreatingmicrosoftfilesserverton
Problem
How to determine what is causing Microsoft SQL Server to create dump files over and over taking up 170 GB of disk space? How do I troubleshoot what is causing the dumps?
The path of the dump files is
Can I delete these?
I have looked at The SQL server Log folder is expanding because of the SQL Dump files (what to do with it ?) but it doesn't really answer my question - it mainly states to contact Microsoft.
The path of the dump files is
C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSQL\Log\Polybase\dump Can I delete these?
I have looked at The SQL server Log folder is expanding because of the SQL Dump files (what to do with it ?) but it doesn't really answer my question - it mainly states to contact Microsoft.
Solution
Since these dumps are being created specifically in the polybase subdirectory, you may want to focus specifically on polybase dumps.
At this link, Niels Berglund shows how TCP protocol being disabled for SQL Server connectivity lead to multitudinous polybase dumps being created.
https://nielsberglund.com/2019/11/20/fix-polybase-in-sql-server-2019-developers-edition/
At this link, Niels Berglund shows how TCP protocol being disabled for SQL Server connectivity lead to multitudinous polybase dumps being created.
https://nielsberglund.com/2019/11/20/fix-polybase-in-sql-server-2019-developers-edition/
Context
StackExchange Database Administrators Q#276294, answer score: 2
Revisions (0)
No revisions yet.