We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

rbmacct
rbmacct asked
on
Medium Priority
187 Views
Last Modified: 2012-09-02
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.
Comment
Watch Question

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
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I just want to close this question.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.