In the 32-bit SQL 2005 Enterprise block, I keep getting "AppDomain XX (DB_NAME.dbo [runtime] .YY) for unloading due to memory pressure."
- I have 8 GB of RAM.
- AWE configured to use 4.5 GB
- No -g512 set of startup parameters
- This SQL instance is listening on 3 different ports.
Among other things, I noticed:
- Little that almost no swap at all
- CPU fluctuates around 20-30%, which meets the standards
- MEMORYCLERK_SQLCONNECTIONPOOL is around 10616
- I get "AppDomain XX (DB_NAME.dbo [runtime] .YY) created", "AppDomain XX (DB_NAME.dbo [runtime] .YY) is marked for upload due to out of memory." AppDomain XX (DB_NAME.dbo [runtime] .YY) is unloaded. "all in one minute, and it repeats every 5 minutes or so.
The database above has only one assembly, and it has been working fine for many months. The problem started only recently, and the only changes I could come up with is an application server that increases the number of connections in its pool from 200-300 to 1000.
Can someone help me shed some light on this issue?
source
share