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.

All Forums  General SQL Server Forums  New to SQL Server Administration  Memory Pressure Issue on SQL 2005 SP3

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,KB977914 As an interim solution we have ramped up memory on server to 32G. Originally it was having 16G