Post reply

Memory

  • May 25, 2004 at 10:03 am

    #82691

    Does anyone have a relatively easy way to determine how much memory a SQL 2k, sp3 server should have. My database is approximately 170 GB and I want to ask for more memory and would like to ask only once and be as accurate as possible.


    Terry

  • May 25, 2004 at 11:03 am

    #507719

    I may not be able to give you exactly how much memory should have.  Actually, SQL Server dynamic memory manager is best at determining how much memory it needs.  It also depends on how much RAM your server has.

    In most cases, I would suggest to leave SQL Server memory as dynamic.

    Also, if you have say 4 GB of RAM, it would give 2GB to the OS and 2GB to the SQL Server.  In this case, you can give it 3GB (1GB to the OS), by enabling the 3GB switch in the boot.ini

    Furthermore, SQL Server, Enterprise Edition, supports up to 64 GB of RAM, but you need to enable AWE (Addressing Windows Extension) and the PAE switch in the boot ini - but that is for large heavy transaction dbs.

    Hope this puts you in the right direction

  • May 25, 2004 at 11:12 am

    #507723

    Sorry, I should have said we currently have 2 GB with it dynamically set. I see a lot of hits on buffer cache and want to try and size up one time.


    Terry

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

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