Hey TeAm,
I have a quick question about how to best get SQL Server running nice and fast on my existing crapola "not-really-a-server" server! Here are my current specs:
P4 2.8GHz Prescott
2 x Seagate NCQ 120GB Drives in RAID 1
Tyan S5120 i915 mobo with SATA RAID 0,1,0+1
1GB RAM
A bunch of other not-so-important parts.
The server is running Win2K3 and running SQL Server 2000. Currently, setting up a database with about 20,000 records (they are product records for an online comp shop!!) and this will be serving a website.
Could you guys recommend what, if anything, i need to upgrade in the hardware? I pretty much know i should go for more memory, SCSI RAID for the SQL Database and logs, but what can I do with my limited, meagre system (and budget)?
Thanks!
Pie
I have a quick question about how to best get SQL Server running nice and fast on my existing crapola "not-really-a-server" server! Here are my current specs:
P4 2.8GHz Prescott
2 x Seagate NCQ 120GB Drives in RAID 1
Tyan S5120 i915 mobo with SATA RAID 0,1,0+1
1GB RAM
A bunch of other not-so-important parts.
The server is running Win2K3 and running SQL Server 2000. Currently, setting up a database with about 20,000 records (they are product records for an online comp shop!!) and this will be serving a website.
Could you guys recommend what, if anything, i need to upgrade in the hardware? I pretty much know i should go for more memory, SCSI RAID for the SQL Database and logs, but what can I do with my limited, meagre system (and budget)?
Thanks!
Pie