Post reply

Sql 2000 and Amount of RAM

  • November 26, 2008 at 11:26 am

    #124544

    I have a server that has 2GB of RAM.

    Sql 2000 is eating up 1.5GB and dont have enough memory to for my BI app.

    I know I can configure the MIN and MAX amount of memory Sql will use in the server properties.

    But does anyone have a recommendation of what I should use as a MAX?

    Is there a calculation I can use to figure what I should have as a man and min?

    Thanks

  • November 26, 2008 at 1:55 pm

    #904025

    Hello,

    Have a look at

    http://www.sqljunkies.ddj.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

    It answers a lot of memory questions.

    Generally I leave 0.5GB-1GB for the operating system (otherwise expect odd errors).

    You might want to check

    SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. This is based on the number of buffers reserved by SQL Server when it is first started up.

    If possible reserve a machine for sqlserver so it doesn't have to compete for I/O,memory and cpu (depending on how heavy it is used)

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

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