Posted by Erland Sommarskog on 10/03/07 21:44

Neil (nospam@nospam.net) writes:
> First, re. the 2 GB of RAM, considering that the db is not huge (two
> main tables have about 60,000 records each; a few other tables with a
> few thousand records; and then a bunch of smaller records); there are
> only about 50 users max; most of the activity is read-only, very little
> writing; and the hardware is brand new; do you think that would be
> enough, or should I push for more? I wouldn't count on the database
> being well-tuned.

More memory is not going to hurt, but the database size you indicate
certainly does not scare me.

> Second, re. the size of the disks, when you said "make sure there is at
> least 50 GB," wasn't sure if you meant 50 GB total, or 50 GB free space
> after SQL Server is installed. Here are the specs for the disks:

I meant 50 GB in total. You are not going to fill up 36 GB on the spot,
but the strategy of Microsoft definitely is to bury a lot of stuff under
C:\Windows.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]