Home / server / Questions / 59656
Accepted
Jedi Master Spooky
Asked: 2009-08-28 09:20:27 +0800 CST

Memory needed for a SQlServer

  • 772

I have a project with a 2TB database (450,000,000 rows). What is the recommend memory? There will be about 200 users at the same time using the info.

sql-server sql-server-2008

3 Answers

  1. Best Answer

    You can go to 32 GB on 32 bit (assuming Enterprise), far more in 64 bit.

    As much as you can afford, basically, within the SQL Server edition limits.

    The data size itself is neither here not there: it's how much is in use at any one time

    • 7

  2. Q: "What is the recommend memeory?"

    A: "The Most"[1]

    [1] For server hardware where read access is a top priority and the data is highly cachable.

    • 4
    1. How much can you afford?
    2. Can you squeeze for more money and get more than that?
    3. It's still not enough. ;-)

    More RAM means more data which can be kept in memory. More data in memory means less data to fetch from disk. Less disk activity means better performance.

    The usage patterns of the application/s accessing the database are more important than the size of the DB, number of rows and number of users.

    • 1