SQL Server grabs all the memory

  • My server info:

    Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) 8GB Ram

    Sql server taking all memory almost 90%

    Please give me any help and scripts

  • Did you set the min/max memory settings?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • It's normal for an active SQL server to grab as much memory as you allow it to grab, especially if there are no other applications asking for memory on that server.

    By itself, that is not a sign of a problem.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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