|
|
Posted by lucm on 10/24/06 20:14
> I am having a SQL Server database of arround 110GB and 250 Users. What
> is best suited hardware requirements for handling of such a database. I
> am having following requirements from the server:
>
> 1. Feeding purpose : On which continously feeding is done by average
> 200 users.
> 2. Reporting purpose : on which average hundred of repords are running
> at a time.
>
> Right now i am having two servers for both of the above said purposes
> with the following configuration.
>
> Feeding Server
>
> HPSERVER 370G4
> 3.2 Xeon Single processor
> 3GB RAM
> 1 SCSI 73GB 15000 RPM(OS & Transaction Log), 4 SCSI * 73GB with RAID 0
> (Data Files) and 2 IDE * 300GB (Backups)
>
> Reporting Server
>
> Board SE7520BD2V
> 2 x XEON 3.2 GHz CPU 800 FSB with 2MB Cache
> 4GB RAM
> 3 SCSI * 73GB with RAID 0 (Data Files and Transaction Log), 2 SATA *
> 300GB (Backups) , 1 80GB IDE(OS)
> Please suggest what should be the configuration for my new server.
> Should I consider buying an Dual Itanium Processor based system with 16
> Gigs of Ram and 8 Hard Disks in Raid 0. Or Should I consider buying a
> Quad Xeon Dual Core Processor based system. Or may be my existing HP
> server can be upgraded to dual processor and 8 Gigs of Ram and 2-3 more
> hard disks? Pls recommend what should be the factors that sould be
> considered, guiding priciples and my approact to reach a decision.
The most critical part in your setup is the I/O. This is where you must
put your money.
Put in as many disks as you can so your RAID arrays will have a larger
span; individual disks will work less, which leads to a better
performance. If you can afford it, get a SAN, which would be very
valuable in your situation. Otherwise you could put two RAID
controllers in your server (one for reporting, one for OLTP) to ensure
that there is as little contention as possible between the two groups
of users.
If budget is an issue, throw as much money as you can in good SCSI
disks for the OLTP then use cheaper SATA disks for the reporting, which
has less frequent disk access and requires more storage. However, keep
a few spare SATA disks as they will fail more often than the SCSI.
As for the CPUs, I would advise you to go with 64-bits Xeon DC+HT, not
Itanium.
When you talk about reporting, do you mean Reporting Services? If so,
make sure to have as much RAM as you can afford, since the reports are
built in-memory (which can be an issue when there is a lot of
concurrent users).
Regards,
lucm
Navigation:
[Reply to this message]
|