September 30, 2008 at 1:59 pm
I have a sql 2005 server running on win 2003 with 16 gig of memory. I have awe and clr. Unfortunately it also hosts some Biztalk db's. I have the max sql memory at 14118.
Here is the boot.ini file
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE /3GB /NoExecute=OptIn
I have had a slew of issues but here is my new one. I got this message today
Failed 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
Anyone had this one before. I have both Biztalk and Sharepoint hosting their db's on this server, so just turning on profiler to troubleshoot is a nightmare, most of what you see come across is greek.
September 30, 2008 at 2:10 pm
remove the /3GB switch from the boot.ini and reboot the server.
This switch is not required and indeed shouldn't be used for machines with 12GB RAM or more
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:16 pm
CLR works outside of SQL's memory buffer ... sounds like your O/S was starved for memory. I agree with Perry, remove the /3GB switch.
September 30, 2008 at 2:24 pm
TBH i'm surprised it's only the apps that crashed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2008 at 2:38 pm
Luckily I have been having RAID and hard drive issues to go along with this
September 30, 2008 at 3:20 pm
that's what i mean, i'm surprised you haven't seen the old BSOD
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply