Post reply

Memory usage

  • June 4, 2003 at 3:44 pm

    #105865

    When monitoring our server (SQL2000) I notice that after a reboot (once a week), memory usage starts out about 10% (of 2gb) and over a day or so climbs to 80% and stays there until the next reboot. Is this normal? Should SQL release memory when it is no longer needed?

    TIA

    John

    John Deupree

  • June 4, 2003 at 8:58 pm

    #459846

    This is a common point of confusion. SQL Server only releases memory on reboots and when the operating systems requests memory. As long as the OS is satisfied, SQL Server will retain memory.

    Larry Ansley


    Larry Ansley
    Atlanta, GA

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

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