In server 2012 and 2016 , SQl error logs show this error message :
"AppDomain is marked for unload due to memory pressure"
Anyone understand what it means ?
1 week after this error came , I capped Max Memory for SQL (70% from Total Memory allocated for SQL) and set up Minimum memory per Query from 1 MB to 4 MB.
and 3 mins after I got this error :
SQL Server Assertion: File: <purecall.cpp>, line = 51 Failed Assertion = '!"purecall"' Pure virtual function call. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
and SQL stopped functioning
What could be the cause ?
Much appreciated your feedback