Forum Discussion
Todd Hank
Sep 18, 2018Copper Contributor
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. ...
Myra Uy
Sep 27, 2018Copper Contributor
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.