Post reply

SQL Server 2005 consumes more memory

  • May 23, 2009 at 4:38 am

    #75472

    Hi to all

    I m using SQL Server 2005 Enterprise edition and Windows Server 2003.

    I have one table name 'tblSavedReports' which has so much data...may b in thousands of lacs..

    When i m accessing that data using stored procedure or normal sql queries

    it takes nearly 1.80 GB of RAM..and i have only 2 GB of RAM.

    Is there any way to minimize the memory usage of sqlServr.exe.

    Is it any memory leakage or something cached of data..

    Please Help me.

    Thank you

    Siddharth

  • May 23, 2009 at 5:35 am

    #999304

    SQL Server will attempt to use all the memory available - if you let it. You should set the MIN_MEM and MAX_MEM options appropriately for your system. I would suggest that 2GB is not nearly enough memory to efficiently host a SQL Server installation with any real amount of data.

    The reason SQL Server uses so much memory is because it will try and load as much as it can into memory. Memory is faster than disk.

    check out sp_configure for the MIN_MEM and MAX_MEM settings or the Memory page under Properties for your instance

    --
    Andrew Hatfield

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

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