Dual Processors

Hi,
I've been recommended a server spec by an application vendor. I plan to buy
and start using this app, and it runs on SQL Server.
The server spec is for a single processor model. There will be a core of
about 25 users on the system with a maximum of 40. How can I decide if I
should buy a dual-processor server? Are there any rules to apply?
Thanks in advance
Steve"Steve W" <antispamsteveW@.=No-Spam=.org> wrote in message
news:uOZCyIhXEHA.376@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I've been recommended a server spec by an application vendor. I plan to
buy
> and start using this app, and it runs on SQL Server.
> The server spec is for a single processor model. There will be a core of
> about 25 users on the system with a maximum of 40. How can I decide if I
> should buy a dual-processor server? Are there any rules to apply?
>
No. Too much depends on how the application is coded and what it does. You
should rely on your vendor to recommend the hardware.
-new servers are incredibilly fast
-single processor servers are incredibilly cheap
-most applications require more IO than CPU
-If you plan on using this server for other applications too you might
want increased capacity.
For small general purpose Intel 32bit SQL Servers I would buy like this:
CPU SCSI disks disk config RAID logical disk config
----
1 2 RAID 1 mirror 10g C: for OS, rest D: for SQL
tables, indexes and logs
1 2 RAID 1 (mirror) (10g C: for OS, rest D: for SQL
tables and indexes)
2 RAID 1 (mirror) (e: sql logs and backups)
2 2 RAID 1 (mirror) (10g C: for OS, rest D: for SQL
tables and indexes)
2 RAID 1 (mirror) (e: sql logs and backups)
2 2 RAID 1 (mirror) (10g C: for OS, rest D: for SQL
tables and indexes)
4 RAID 10 (mirror/stripe) (e: sql logs and backups)
And buy have as at least as much ram as you have data in your databases, up
to 2g.
David