Selection of Hardware for sql2005 DB
Hi,
our database size for sql 2005 standard edition is now around 30 GB ,
but since there are more data which need to be added to database and
expecting that it would be
around 1-2 TB , what should be the minimum RAM and Processor requirement
for this kind of database to give better performance.
with regards
Also Take a Look at the Microsoft Recommendations ...
I know it's kinda obvious, but be sure to look over the published requirement guidelines at the Microsoft SQL Server site ...
Bill
Partitioning / Using Multiple Drives ...
Partitioning / using multiple drives can also mean parallel writes - and therefore increased speed. I've seen some excellent schemes for setting this up recently.
Bill
Thanks for the Feedback ...
Thanks for getting back and making that clear. Many will come across this thread via searches, and I'm sure that this will make things more understandable.
Have a great weekend.
Bill