允许 CLR 使用内存
我们遇到了一个问题,当我们尝试更改 SQL Server 中的 clr 程序集时,我们收到此错误消息:
Failed to initialize Common Language Runntime (CLR) due to memory pressure.
This is probably due to memory pressure in the MemToLeave Region of memory.
Error 6513
我找到了有关查看允许 CLR 使用多少内存等信息,并且遇到了此查询。
查询:
select
single_pages_kb + multi_pages_kb + virtual_memory_committed_kb
from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'
当我运行它时,我得到以下信息:
11676 kb or about 11MB
这是否意味着 CLR 只允许使用 11MB 的 MemToLeave 内存?
谢谢,
S
We have been running into an issue where we get this error message when we try to alter a clr assembly in SQL Server:
Failed to initialize Common Language Runntime (CLR) due to memory pressure.
This is probably due to memory pressure in the MemToLeave Region of memory.
Error 6513
I found information about looking at how much memory the CLR is allowed to use, etc and I came across this query.
Query:
select
single_pages_kb + multi_pages_kb + virtual_memory_committed_kb
from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'
When I run it I get this:
11676 kb or about 11MB
Does that mean that the CLR is only allowed to use 11MB of MemToLeave Memory?
Thanks,
S
MS 支持知识库:
使用 SQL 时“无法初始化公共语言运行时 (CLR)”的可能原因CLR
有一个链接到 各种使用 SQL CLR 对象时,内存错误会记录到 SQL Server 错误日志
...其中对 SQL Server 2005 和 2008 有一些建议
MS Support KB:
Possible causes of "Failed to initialize the Common Language Runtime (CLR)" when using SQL CLR
Has a link to Various memory errors are logged to SQL Server error log when using SQL CLR objects
... Which has some suggestions for both SQL Server 2005 and 2008