Microsoft servers software and hardware upgrade

25 pts.
Tags:
HP ProLiant
SQL
SQL Server
Windows Server
We have the following architecture: 2 Microsoft SQL servers. OS is windows 2000. SQL database  is 7.0. The server hardware is HP proliant 800. The server is a SQL applicaiton server. The server is used for data mining. RIght now it has a script that used bulk inserts to push "csv" files to the database. The database size is about 10 Gb. We are looking to upgrade the hardware and software. The following are some hardware someone suggested (for each server): This server: 2,339.00 http://h10010.www1.hp.com/wwpc/us/en/sm/WF06b/15351-15351-3328412-241644-241475-3821728-3834653-3834654.html Hard Drives: 2 of These Hard Drives: 549.00 each ( E Drives ) 1 year warranty http://h30094.www3.hp.com/product/sku/3867580/mfg_partno/461135-B21 2 of these Hard Drives: 359.00 ( C Drive ) 3 year warranty http://h30094.www3.hp.com/product/sku/3706645/mfg_partno/384854-B21 1 of these: 130.00 http://h30094.www3.hp.com/product/sku/3867558/mfg_partno/481043-B21 What do you thing of the suggested hardware. Obviously it's missing the software. I need a solution for both hardware and software upgrade. Can you make a suggestion?



Software/Hardware used:
Microsoft windows 2000. HP proliant 800

Answer Wiki

Thanks. We'll let you know when a new response is added.

Based on the very old hardware and software that you are currently running just about anything that you can buy today will be a major improvement.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • OwenAmbrose
    What you have listed is a good setup. If money is not an issue then always go for the best spec you can get as this gives you the most future-proofing. The 15k SAS drives are the best option to run a database on as they'll give you the fastest access speeds. One thing you may want to consider is adding extra drives in a RAID config to give you some redundancy should one drive fail. Even if you do not have a RAID set up it is good to have a spare drive in the event of a failure. As far as software, ideally you want SQL 2008, but you are going to have to read-up on the process of migrating from SQL 7.0 to 2008. I know there are tools to assist in going from SQL 7.0 to SQL 2000, but am not sure how easy it is to jump up to 2008. You should get Windows Server 2003 or 2008. For the work I do, there is no major difference between 2008 and 2003 and I prefer 2003 personally. I don't do much with SQL so don't know if there is an advantage to running it on 2008 over 2003 (or vice-versa) Whether you go for Standard, Small Business, or Enterprise depends on your company size. I don't know what you currently do for backups, but I would connect an external drive big enough to hold at least 7 - 10 backups, and also put in place some sort of off-site backup I would get BackupAssist software it's really good and supports SQL backups though I've never used it for one myself. I frequently use it for data and Exchange backups, and Rsync offsite backups.
    1,930 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following