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 |
vinu.
Starting Member
2 Posts |
Posted - 2010-03-20 : 09:04:16
|
Hi- I have Windows 2003 EE 64bit MSCS cluster (two node), having SQL 2005 SP3 hotfix 4262. For last couple of days we are experiencing performance issue on server where server takes very long time to respond and goes low on memory. When I checked the logs, i found this error message in event logs- "AppDomain 2 (DBname.dbo[runtime].1) is marked for unload due to memory pressure". The passive cluster node remains fine during the issue. The only resolution what we have now is to reboot server to fix the issue. I have also observed disk related event IDs 50, 26. The storage is netapp file on iSCSI.For the above error message i found http://support.microsoft.com/kb/917271 , but it is applicable for sql 2005 sp1.Recently we have deployed MS patches on server three days before we experienced the issue. Patch details:KB978037,KB978706,KB978251,KB975560,KB978262,KB971468,KB977914As an interim solution we have ramped up memory on server to 32G. Originally it was having 16G |
|
|
|
|