Delete Ploybase dump files in SQL Server2019, is it affect Database or performance of sever

Shabin Suresh 211 Reputation points
2023-09-21T12:38:49.9533333+00:00

Hi Team,

We have a Server 2019, includes SQL Server 2019 with 4 instances, in one instance C:\Program Files\Microsoft SQL Server\MSSQL15.SGSFAROOJ\MSSQL\Log\Polybase\dump have 500GB size. We are not using Polybase services. So if we delete those logs, any issues will occurs. Kindly advise and check attached image.

Thanks,

Shabin

Windows for business | Windows Server | User experience | Other
SQL Server | Other
0 comments No comments
{count} vote

Accepted answer
  1. Anonymous
    2023-09-22T05:47:34.1033333+00:00

    Hi @Shabin Suresh

    You can refer to the discussion in this thread: https://learn.microsoft.com/en-us/answers/questions/334078/polybase-issue-about-continuous-producing-of-dump.

    The answers to this thread include stopping the Poly database service through the SQL configuration tool to resolve this issue. But as Erland said, a better solution is to apply the latest cumulative update.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Shabin Suresh 211 Reputation points
    2023-09-21T12:41:31.4366667+00:00

    LOG_PolyBase_SQL

    0 comments No comments

  2. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2023-09-21T21:51:13.9366667+00:00

    You can delete those files without issue.

    These files are the result of a known issue with the release version of SQL 2019. Make sure that you have the most recent Cumulative Update installed, so that you don't get new dump files.

    If you have Polybase installed without using it, you may be inclined to uninstall it, but I cannot really recommend that. That is, I tried removing Polybase from my SQL 2019 instance, but this failed.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.