Post reply

SQL Server not using much memory

  • March 18, 2010 at 7:05 am

    #217916

    We just installed a SQL Server 2005 Developer Edition x64 on Windows Server 2008 Standard x64. The server has 24GB of memory and several databases. Some of the databases are over 100GB in size. The old server that we migrated from was only 32-bit and therefore was maxing out at 2.8GB of RAM. However, on this new box, with all of this memory, it won't use much more than 85MB of memory. Is there something we're missing in the configuration? Our production box has 32GB of memory and SQL Server uses all of it. Performance is hindered since it won't use the memory it has available.

    SQL Server is using SP3 and Windows has SP2 installed.

  • March 18, 2010 at 7:17 am

    #1135926

    Duplicate Post

  • March 18, 2010 at 7:19 am

    #1135928

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885461-146-1.aspx

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply