December 16, 2019 at 5:46 am
Hi All,
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
December 16, 2019 at 7:06 am
Memory leakage in some of your SQLCLR code? Usage of unsafe/old assembles, check logs?
December 16, 2019 at 8:47 am
Thanks for the response
how do I know if it is due to memory leakage in sqlclr code ?
December 16, 2019 at 10:46 am
I'm not sure if it will help but if it's due to memory leak in SQL 2016 then you can give a try using this
You can also give a try here.
Additionally, below articles should give you some insights to check the memory pressure.
https://blogs.msdn.microsoft.com/buckwoody/2010/06/29/the-windows-page-file-and-sql-server/
https://www.sqlshack.com/sql-server-memory-performance-metrics-part-6-memory-metrics/
My blog : https://sqlservercarpenter.com/
LinkedIn : https://in.linkedin.com/in/brahmanand-shukla
December 16, 2019 at 2:43 pm
Total Server Memory = ??
How Many SQL instances on the server??
How much Mem reserved to the O/S.
Windows will require 4gb of mem or 10% of the total memory which ever is the greatest.
Are plans being flushed from the cache too.
December 16, 2019 at 5:05 pm
Disable your anti-virus. See what happens.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 16, 2019 at 10:01 pm
Total server memory = 32 GB
only 1 SQL instance
Memory for SQL is 22.4 Gb , the rest of OS
Are plans being flushed from the cache too-> what do u mean ?
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply