Memory Usage by SQL CLR
http://blogs.msdn.com/sqlclr/archive/2006/03/
24/560154.aspx shows how to find out the amount of memory used by the SQL CLR.
A very useful SQL snippet given by the above blog entry is
select single_pages_kb + multi_pages_kb + virtual_memory_committed_kb
From sys.dm_os_memory_clerks
where type = 'MEMORYCLERK_SQLCLR'
24/560154.aspx shows how to find out the amount of memory used by the SQL CLR.
A very useful SQL snippet given by the above blog entry is
select single_pages_kb + multi_pages_kb + virtual_memory_committed_kb
From sys.dm_os_memory_clerks
where type = 'MEMORYCLERK_SQLCLR'
0 Comments:
Post a Comment
<< Home