Difference between running MS SQL Server 2000 on a desktop PC and a Server

[Ambrose]

Hi Everyone,

Apparently, I was being asked on a question, "Why don't we procure a
desktop PC to run MS SQL Server 2000 rather than a buying a server?".
From a Management point-of-view, buying a desktop PC is much cheaper
than a server. However, I just wanted to understand that is it a
viable solution given the database size is something around 200 GB?
Equipping with more memory, more storage and a more powerful CPU on a
desktop PC could really taking up the role to support the DBMS?

Besides this "sensitive" costing concerns, what will be others
difference in running the SQL Server 2000 on the two different
hardware architecture? For example, IO rate, reliability, RAID-1
support, performance, … etc.

(Note: The operating system is Microsoft Windows 2000 Enterprise
Edition)

Regards,
Ambrose

[Greg D. Moore \(Strider\)]

"Ambrose" <ac****@hec.com.hk> wrote in message
news:6e**************************@posting.google.c om...

Hi Everyone,

Apparently, I was being asked on a question, "Why don't we procure a
desktop PC to run MS SQL Server 2000 rather than a buying a server?".
From a Management point-of-view, buying a desktop PC is much cheaper
than a server. However, I just wanted to understand that is it a
viable solution given the database size is something around 200 GB?
Equipping with more memory, more storage and a more powerful CPU on a
desktop PC could really taking up the role to support the DBMS?

Well, there's a lot of questions here.

How valuable is the data? I mean a 200GB SATA drive is cheap these days.
But if it fails, you're hosed.

I've run some small non-critical databases on workstations. Heck, if it was
non-critical, I might run a large (i.e. 200GB one) on a work station.

However, if it's critical, then I'm starting to look at things like ECC
memory, RAID, etc.

So, sure, the desktop is cheaper... but what if you lose your data? Or are
down for 10 hours restoring it from backup?

Also, if it's high volume, I'm looknig at RAID, multiple channels of RAID,
multiple NICs, multiple XEON CPUs. etc.

Besides this "sensitive" costing concerns, what will be others
difference in running the SQL Server 2000 on the two different
hardware architecture? For example, IO rate, reliability, RAID-1
support, performance, . etc.
MS Press has a book (don't recall the title) on this.

(Note: The operating system is Microsoft Windows 2000 Enterprise
Edition)

Regards,
Ambrose