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/
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy