question

vijay 2 avatar image
vijay 2 asked

Error 6513 Failed to initialize the CLR due to memory pressure

Hi Everyone, 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". Thanks, Veejay
sqlerror-messageclrcomputed-column
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
The error message is pretty clear here. There is a computed column on `tbl_users` that is computed using a CLR function. This cannot be loaded due to memory pressure on your system. 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?).
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
With reference to , the message is suggesting that you do indeed have memory pressure and points you towards 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 `tbl_Users` is the culprit - you may want to post the definition here to see if anyone can help with that.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.