0

SQL server created a lot of SQLDump.txt files in log folder I'm using SQL server 2017, but I have two databases in My SQL server. I find out my problem isn't about to shrink Ldf file I checked it out. I researched about Error Logs, SQL log, and transaction log. I don't know how to find out which of them are my issues?

Microsoft SQL Server 2017 (RTM-GDR) (KB4494351) - 14.0.2014.14 (X64)
Apr 5 2019 09:18:51 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

enter image description here

1

You have something seriously wrong going inside the SQL Server and that is why it is producing so many dumps and if you look closely dumps file SQLDumpxxx are getting dumped every minute of so this may be due to bug in SQL Server or sql server facing some exception because of queries running. I would start by looking whether the SQL Server is patched to latest SP and CU or not. If you run select @@version and add the output in the question I can tell you the SP level. You can also find SP/CU information about SQL Server 2017 on SQLServerbuild.blogspot.com.

Similar question discussed on This Thread

MS engineers are the best person to analyze these dumps and tell you what is causing this but before opening case with MS please make sure the SQL Server instance is patched to latest SP and CU so that you rule out all the possibility of bug. If you go to them without patched SQL Server they are most likely to ask you to update to latest SP.

Some links which show how to analyze dumps

SQL Server Diagnostics (Preview)

Looking deeper into SQL Server using Minidumps

Steps to Catch a Simple “Crash Dump” of a Crashing Process

Extracting Information from Crash and Hang Dumps

The first 2 links should be good if you want to try it yourself but my suggestion would be to make sure latest SP and CU is there and if that does not solves the issue raise case with MS.

Microsoft SQL Server 2017 (RTM-GDR) (KB4494351) - 14.0.2014.14 (X64)

You can see the version is RTM you need to apply SQL Server 2017 CU15 and see if that resolves the issue

2
  • I updated, but of course, it didn't solve.
    – Behnam
    Jul 6 '19 at 14:49
  • Can you add output of sp_readerrorlog in the question. And how do you say it did not solve, are you still seeing the dumps?
    – Shanky
    Jul 6 '19 at 17:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.