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

Posted on 2011-04-25
Last Modified: 2012-09-02
SQL 2008 Target Server Memory value goes up and down for no reason.

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

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.

Question by:rbmacct
    LVL 10

    Expert Comment

    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
    LVL 1

    Accepted Solution

    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.
    LVL 1

    Author Closing Comment

    I just want to close this question.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now