Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

PC Tech Specs Advice

May 8, 2005 11:38AM PDT

My company is going to buy a computer. This computer needs to have at least Win XP Professional OS, and will be installed with MS SQL 2000. It will be mainly used for:

1. Transferring files to the web hosting company's shared web server
2. Transferring data from the internal server (intranet) to this PC
3. Transferring data from this PC to the shared database server of the web hosting company
4. Performing scheduled jobs (that will involved executing distributed SQL statements, some stored procedures) between our own SQL server and the shared database server using MS SQL 3 times a day
5. Running the Distributed Transaction Coordinator, SQL Server, and SQL Server Agent of MS SQL 2000 whenever the PC is on
6. Backing-up data from the shared web server and database server daily
7. Sending e-mail when the scheduled jobs failed

I think speed and security will be the most important. I'm not sure because I have no experience in buying PC at all.

What technical specs would you recommend for the PC? Which processor? How much memory? What hard drive? How much power? Which brand? ...

Please help... Thank you in advance.

Discussion is locked

- Collapse -
In addition...
May 8, 2005 1:29PM PDT

Btw I just want a normal PC (not a server). This PC acts actually like a middleman that transfers data from our company to the web hosting company's server using MS SQL which will also process the data. The data is very small, less than 2-3 MB. But it's going to perform this job 3 times a day.

- Collapse -
RE:
May 8, 2005 1:52PM PDT

Dell 4700C.
Roger