Monitor SQL Server CLR Reserved Memory

Question

I recently turned on the CLR on my 64-bit SQL Server 2005 computer to use about 3 proc. When I run the following query to collect memory usage information ...

select single_pages_kb+ multi_pages_kb + virtual_memory_committed_kb as TotalMemoryUsage, virtual_memory_reserved_kb from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR' 

I get

129 mb MemoryUsage and 6.3 gb virtual memory reserved

The total memory of the car is 21 concerts. What does reserved virtual memory mean exactly and how can I manage distributed size? 6 gigabytes is an overkill for what we do, and memory will be much better used by the sproc cache. I am worried that this reserved memory will lead to the replacement of the page file.

Please help me regain control of my memory!

thanks

Answer 1

You are using 64 bits, so VAS (virtual memory) is not a problem.

Virtual memory is not actually used or allocated. He just reserved a range of addresses.