Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2009-01-15 : 11:56:05
|
| I am trying to create a CLR stored proc, after I run the script to create the assembly in SQL sever:----------------------CREATE ASSEMBLYhzFileMover_assembly -- Assembly name, you can write which you wantFROM 'C:\myDll.dll' WITH PERMISSION_SET = SAFEgo----------------------I get the following message:--------------------------------------Msg 6513, Level 16, State 27, Line 1Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.-----------------------------------------My sql Sever Server has 3.5GB in RAM an drunning windows server 2003 R2 sp2.----------------------------------------according to BOL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d308d9cb-bb85-46f6-93c6-e2ddd0fa01c3.htm)I am about to reconfigure the server so that it can use AWE. My question is:Is there anything I should be aware of before making this move? Am I going to affect how the SQL Server currently works if I switch to AWE mode?Thank you |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-01-15 : 16:20:17
|
| What is the current percentage usage of SQL Server Memory?AWE will give extra memory to the Data extensive applications. Are you running any other applications apart from sql server in the box.Vichttp://vicdba.blogspot.com |
 |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2009-01-15 : 16:25:42
|
| no, only sql server 2005 is running on the server |
|
|
|
|
|
|
Address Windowing Extensions (AWE) a problem?