Wednesday, March 21, 2012

New Setup Question

Hi there, a client asked me to make some recommendations as to the hardware setup for a new SQL 2000 setup. They will be importing a 9 gig sql 7 DB...

Specifically I'm looking for Optimal Raid configurations and Memory. Initially I was going to recommend a dual CPU machine with a raid 5 for the DAta, and rain 1 for the transaction logs. Is that still the recommended choice.

Also if they wanted to do a fail ever cluster I assume they are going to have to add an additional CPU license if the backup machine was a single CPU?Please provide more info about transactions nature. For high level of concurent transactions with high activity on writes RAID5 is not appropriate choise.

No comments:

Post a Comment