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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you also attach the file C:\Program Files\Microsoft SQL Server\MSSQL13.POSEIDON\MSSQL\LOG\SQLDump10000.txt ?
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

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
Vitor MontalvãoMSSQL 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.