When I tried to execute following query in SQL Server 2008, below mentioned error is cropping up. Please help…
Query: select * from tbl_users
Error Message: Msg 6513, Level 16, State 27, Procedure tbl_users, Line 1 Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online. Msg 474, Level 16, State 0, Line 1 Unable to load the computed column definitions for table "tbl_users".
With reference to http://support.microsoft.com/kb/2003681, the message is suggesting that you do indeed have memory pressure and points you towards http://support.microsoft.com/kb/969962 which will guide you towards possible solutions and further reading.
I would be very careful applying any changes to the MemToLeave (you can easily find many references and 'fixes' about this on Google) - in the past I have only applied memory config tweaks AFTER consulting with Microsoft Support. If you have a support contract or MSDN subscription with support, I would be tempted to use those.
As for the cause - the 'computed column' in the definition of
answered Sep 03 '10 at 04:51 AM
Kev Riley ♦♦
The error message is pretty clear here. There is a computed column on
Take a look at the system to see what is using all the memory and sort that out. A starting point may be to see how SQL Server memory min. and max is set. Maybe set the max setting a little lower to free up some system memory. However, I am not too sure about memory management for SQLCLR and how that is governed (anyone else?).
answered Sep 03 '10 at 04:44 AM