Memory pressure notification in SQL CLR

Question

Google is not able to tell me if there is an API available inside the SQL CLR to get memory pressure notification.

It is obviously used, since the AppDomain will get unloaded under memory pressure, but the question is if the notification is sent to into the AppDomain prior to the unload, so that I could release some cache memory.

(My dll is already running in unsafe mode, so that is a non-issue)

I would be interested in this as Im having some memory pressure problems running some CLR stuff — samaspin
– samaspin, Commented Nov 28, 2011 at 11:24

Cine · Accepted Answer · 2014-08-15 10:30:15Z

1

In SQL 2012, they implemented a new query that allows you to get the current memory usage...

select survived_memory_kb from sys.dm_clr_appdomains where db_id = DB_ID()

It doesn't give you the memory pressure, but it does allow you to monitor the usage of memory, and thus adjust based on your own logic.

answered Aug 15, 2014 at 10:30

Cine

4,43930 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Memory pressure notification in SQL CLR

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related