SQL Server 2016 crashes

Brass Contributor

Hey Guys,

 

I am facing really weird issue with MS SQL 2016 crashes. Every so often there is a crash dump generated:

 

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

 

This information is very vague so you cannot really determine what is the cause of it. I was playing with the dump file a bit An I got into the module that is causing the crash:

 

ntdll!NtWaitForSingleObject+0x14:
00007ffb`d5255ac4 c3              ret

 

 SQL is working the cluster with 4 nodes. Two nodes are in one site and two other nodes are in the second site. Network is working fine. There are no error logs inside the system event viewer or Failover Cluster operational logs.

 

I have noticed that we are running on older version of ODBC drivers which is 17.3.1.1 and the newest one is 17.4.2.1. Do you think this might be related?


Regards,

Wojciech

0 Replies