Forum Discussion
SQL 2008 R2 Service Terminating Unexpectedly - Access Violation
We have SQL 2008 R2 SP2 and it is terminating and restarting daily. This is a big problem because it has our company financials application on it and uses are kicked out while the service restarts.
I have attached the SQL dump file for your review.
Additionally, when it does go down we get the following entries on the exception log:
09/18/18 00:03:19 spid 205 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 00000F0054097B98 at 0x00000000771CEEF1
09/18/18 00:03:33 spid 206 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 000000FF58FAB4D8 at 0x00000000771CEEF1
We have tested all the databases for errors and the backup jobs do not seem to be a problem either.
Lastly, We cannot upgrade the SQL server to anything higher that 2008 R2 SP4 because the accounting package will not run of anything higher.
I would appreciate any assistance.
Todd
1 Reply
You need to fix SQL memory first. You have very low available memory and if you haven't set the max server memory yet, you need to set it. You can leave at least 4 GB of memory to the OS if this is a dedicated SQL server. Also, it looks like you have some 3rd party DLL or modules in SQL address space, you need to unload it from SQL memory. You can check this link:
https://support.microsoft.com/en-us/help/2033238/performance-and-consistency-issues-when-certain-modules-are-loaded-int
Hope it helps.
