SQL Server Gems

Monday, April 03, 2006

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'

0 Comments:

Post a Comment

<< Home