Post reply

SQL SERVER RUNNING OUT OF MEMORY

  • February 3, 2006 at 2:59 am

    #116132

    Hi,

    We have been looking at the performance of our Intranet SQL Server particularly the memory.

    Our server has 1GB or physical memory, with a paging file of typically 2GB.

    When the server has been rebooted the physical memory available is typically 500/300M, during the course of the day it gets to as low as 12K!

    Is this normal, does it get reallocated when the system needs more?

    In task manager the memory usage of sqlservr.exe is 770M.

    Thanks.

    Mike

  • February 3, 2006 at 8:03 am

    #618680

    This is normal. SQL Server will allocate some at boot and begin to request more from the OS as it feels it needs it. 1GB is pretty low and I'd recommend at least 2 if there is any kind of load or other processes. You can limit the amount SQL takes in Enterprise Manager (server, right click, properties, memory tab).

  • February 3, 2006 at 8:24 am

    #618692

    Thanks, will up the memory, cheers. Mike

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

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