[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

SQL 2008 Target Server Memory value goes up and down for no reason.

SQL 2008 Target Server Memory value goes up and down for no reason.

Environment:
MS-SQL Server Enterprise Edition x64, running on Windows Server 2008 with 24GB and it is dedicated db server.
Scenario:


The Target Server Memory counter is around 22 GB most of the time, however last week I noticed that the counter value gradually went down to 12GB in 2 days period, then suddenly started to going down to 1GB approximately every 10 minutes.  Eventually it recovered back to 12GB but then went down again that last all day long.

Also the Total Server Memory counter was never above 1.3 GB during that period.

This happened for apparently no reason there was not stress on the server.  I fixed the problem by restarting SQL Windows service. I had similar scenario 3 months ago.

I checked some articles that talk about “Cache Bytes” and “System Cache Resident Bytes” but both values were around 115 MB.

I cannot figure out the root of the problem, any idea of where to start tracking this issue.

Thanks.
0
rbmacct
Asked:
rbmacct
  • 2
1 Solution
 
Ramesh Babu VavillaCommented:
SQL Server 64 bit never releases memory in SQL Server 2005/2008.the max occupiant of memory in SQL Server if Buffer Manager,
Do you have memory cap for SQL Server min and max memory ?
set min as 4096 and max memory as 22 GB
0
 
rbmacctAuthor Commented:
Yes I do have set max but not min.  

The weird thing is that the server was behaving “normal” for the last 3 months. One of my y main concerns at this time is to try figuring out why the Target Server Memory counter was going up and down from 12GB to 1GB every 10 minutes for apparently no reason. That is not the normal behavior of my Server.

Thanks for your feedback.
0
 
rbmacctAuthor Commented:
I just want to close this question.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now