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 |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2010-10-19 : 05:33:52
|
| Windows 2007 Enterprise X64 - 12gb RAM - SQL Server 2008 StandardWe are seeing major performance issues over the past couple of days. Lots of the following errors:AppDomain x (xx.dbo[runtime].303) is marked for unload due to memory pressure.SQL Server max memory was set to 9gb but there was also considerable pagefile usage so I have decreased SQL to use 8gb which seems to have helped but in no way has cured the situation. Is this simply because there is not enough RAM installed? SQL Server is at RTM so could this be resolved by patching to SP 2? Any ideas would be greatly appreciated.Thanks. |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2010-10-19 : 06:01:31
|
| I am seeing some suggestions online that in this scenario it is worth disbling hyperthreading to see if that has an effect. I am struggling to see the correlation between cpu and ram here though or is that just me......? cpu is certainly not under stress, does memory have to work harder to maintain hyperthreading? |
 |
|
|
|
|
|
Memory issues