SqlDumpExceptionHandler: Process 41 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

PLEASE

view attachment

The files . mdmp are being saved in the Log folder of Disk C where SQL Server C: \ Program Files \ Microsoft SQL Server \ MSSQL13.POSEIDON \ MSSQL \ Log is installed, the .mdmp files are equal to the dump file I think, when you I right click on a dump file and see its properties, its extension is .mdmp

On the C disk the mdf and ldf files of the databases are not being saved, on the C disk there are only the installation folders and the 223 GB weight of the log referred to the Log of the installation folder C: \ Program Files \ Microsoft SQL Server \ MSSQL13.POSEIDON \ MSSQL \ Log and it's just so heavy because every day a lot of Dump files are being generated

 On the other hand, we do not have visible problems with the bd server, everything works fine, it does not fall or anything, that's why I wanted to know why so many dump files are being generated daily or how could I identify what is happening to solve it? that eliminates the dump files and frees a little space, in a few days it is full again.
enrique_aeoAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Error log only has error messages from SQL Server. The dump file has a snapshot of the server memory when the error occurred. Since they are related, the same information can appear in both files. Unfortunately I was expecting to find more differences in the dump file but I couldn't find nothing that can lead to find the root cause for your issue.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
There's no attachment.
mdmp is a mini-dump file, meaning that's a dump file with less information than usual but should be enough to use for troubleshooting.

Can you attach the last SQL Server error log?
0
 
enrique_aeoAuthor Commented:
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you also attach the file C:\Program Files\Microsoft SQL Server\MSSQL13.POSEIDON\MSSQL\LOG\SQLDump10000.txt ?
0
 
enrique_aeoAuthor Commented:
What is the difference between the ERRORLOG and the SQLDump10000.txt, how are they generated? They seem to have similar information.
It weighs almost 1 GB the file, is it normal?
log_cibertec.txt
0
 
enrique_aeoAuthor Commented:
then what should I do?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you have Microsoft's support then contact them. You should also provide them the error log and dump files so they can perform their troubleshooting. Usually they have the necessary tools to analyze the dump file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.