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:
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 18.104.22.168 and the newest one is 22.214.171.124. Do you think this might be related?