October 26, 2012 at 2:48 am
Hello Masters,
Currently my sqlserver.exe is consuming 12.4 GB of memory, which much more than Max memeory allocated to it. Total server memory is 16 GB, Its live production server.
How can i solve the issue? Can the restarting is the only option ? Is there any other way to solve the issue?
October 26, 2012 at 3:07 am
do you have trigger in your any DB.(trigger may occupy lot memory)
as per my knowledge Sql server will utilize more memory(if its Free,no process required memory) unless and untill some other process wants it.it will release memory when other process wants that memory,
if you restart your sql service then also after some peroid off time it will be on same stage occuping
memory.
October 26, 2012 at 3:07 am
Max server memory controls the buffer pool. There's a small amount of memory used above that, it's called non-buffer memory, usually just a couple hundred MB, but can get a little larger.
If SQL is consuming too much memory, drop max server memory down slightly.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2012 at 4:16 am
Hi Gilamonster,
I lower down the max memory allocation but still no effect. Has I need to restart the services ? Or any other solution?
My Sql server 2005 is on Windows server 2003. Is there anything that can help me to lower down memory consumption ?
October 26, 2012 at 5:01 am
Reduce max server memory, SQL will reduce it's memory usage when you do that. It'll still be allocating more than max server memory, as I explains that setting controls the buffer pool only, not the non-buffer memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2012 at 5:21 am
but i suppose that if u change the Max Server Memory parameter, the SQL instance needs to be restarted. Is it?
October 26, 2012 at 6:15 am
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply