Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2008
    Posts
    56

    Unanswered: Memory Issue SQl Server 2005

    Hello,
    I have a 2005 server that did have 4gb of memory. We upgraded to 8gb because the server stats were showing that 97% of memory was being used. After the upgrade to 8gb we are still showing 97% of memory being used.
    The stats show that SQL is using 6,697 mb of it. Of that the buffer cache has 6,694 mb of active pages.
    Is this common or should I look for ways to reduce the cache?
    We are running SQL Server 9.00.3077.00 SP2 Enterprise Edition (64-bit)

    Thanks for you help and advice

    Rebecca

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Left to its own devices, SQL Server will use as much memory as you give it. Are you having errors related to memory, or seeing high disk read/write activity?

  3. #3
    Join Date
    Oct 2008
    Posts
    56
    the disk(s) are busy only about 4% of the time. Two local disks and San storage. The average disk queue length is about 1.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yes, SQL Server is optimised to retain as much in cache as possible. Why write a page to disk and clear the cache only to risk having to read it back again any second? Unused memory isn't really any use to it. It only flushes the cache when there is pressure to do so, or you instruct it to.

  5. #5
    Join Date
    Oct 2008
    Posts
    56
    So is it wise to just let things run as they are? I haven't noticed any performace issues but the memory being used by the buffer cache was rasing a red flag in my mind.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The best measure of memory pressure in SQL Server is not how much SQL Server is using but how often a request cannot be met by what is in the cache. Look at the Buffer Hit Cache Ratio % in perfmon. Or you could just keep buying RAM until you have enough to store all your databases in memory

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •