January 7, 2015 at 10:40 pm
Hi friends
At one of our client site we are continously getting following messages in error log.
AppDomain 918 (OperationsManager.dbo[runtime].1219) is marked for unload due to memory pressure
AppDomain 918 (OperationsManager.dbo[runtime].1219) unloaded.
AppDomain 919 (OperationsManager.dbo[runtime].1220) created.
AppDomain 919 (OperationsManager.dbo[runtime].1220) is marked for unload due to memory pressure.
AppDomain 919 (OperationsManager.dbo[runtime].1220) unloaded.
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 128924, committed (KB): 252908, memory utilization: 50%.
AppDomain 920 (OperationsManager.dbo[runtime].1221) created.
what perfmon counter should i used to check memroy prerssure and other dmvs before procedding ahed with client ofr demand of more memorry
sql server is 2008 r2 standarad 64 bit edition
ram is 2gb
and os is Windows server 2008 R2 standarad
Regards
Anoop Pandey
January 8, 2015 at 3:24 am
RAM is 2 GB ?
MS recommendation is 4GB or more I believe.
January 8, 2015 at 3:25 am
You should enable lock pages in memory for the SQL service account:
https://support.microsoft.com/kb/918483
But 2GB is pathetically low memory for a SQL server. Unless your db is tiny, bump that memory up!
January 8, 2015 at 4:23 am
It's basically a message telling you that you're running SQL Server on a grossly underpowered machine. 2gb is just the bare minimum to get the server started. You need more memory.
What happened is that you had some data in cache and then a query was run requiring all the memory to be flushed out to disk in order to load data from the new query into memory. This will keep happening.
Get more memory.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply