Monday, March 26, 2012

Replication Cost

I know this question can depend on many things but I want
to get a rough estimate.
If I have 2 CPU with each 1 Ghz and 2GB of physical memory
on a server and I also have 3 Database with the size of
~10GB each. What could be my replication cost if I
replicate all 3 databases to another server in the
domain'. Currently, I am restoring my backups on the
second server in case if I loose my primary production
server. Since I have transaction log backups every hour, I
will be loosing last 1 hour of data if my primary server
crushes. I also have total of 300 user loging on and doing
transactions on the server.........
SQL Server 2K Std Edition, Windows 2K
Thanks for any suggestions.......You didn't mention anything about RAID, Mike, but if server isn't set up for RAID 5, it should be. I don't know the cost involved for your server, but my Compaq ML530 with all the bells and whistles (dual 1GB processors, array controller, drive cage, hot-pluggable 18.2GB drives, three power supplies, DLT drive, 2GB memory) cost about $18,000 about three years ago. I do remember that the array controller alone was about $1,800 because it went bad and had to be replaced. I don't recall the cost of the other items necessary for RAID 5 configuration, but it was in the neighborhood of $7,000. Of course, you could probably get all that for about half today
If you're look for a belt and suspenders approach, you could set up yuor current server as RAID 5, and then get another identical server and do some kind of disk mirroring between them. You'd have total redundancy without the need for replication or the overhead it requires, and if one server craps out the other could take over seemlessly
You should talk to your hardware people and see what's available
John|||Yes. We have the RAID5 and both servers are mirrored....
Thanks.
>--Original Message--
>You didn't mention anything about RAID, Mike, but if
server isn't set up for RAID 5, it should be. I don't know
the cost involved for your server, but my Compaq ML530
with all the bells and whistles (dual 1GB processors,
array controller, drive cage, hot-pluggable 18.2GB drives,
three power supplies, DLT drive, 2GB memory) cost about
$18,000 about three years ago. I do remember that the
array controller alone was about $1,800 because it went
bad and had to be replaced. I don't recall the cost of
the other items necessary for RAID 5 configuration, but it
was in the neighborhood of $7,000. Of course, you could
probably get all that for about half today.
>If you're look for a belt and suspenders approach, you
could set up yuor current server as RAID 5, and then get
another identical server and do some kind of disk
mirroring between them. You'd have total redundancy
without the need for replication or the overhead it
requires, and if one server craps out the other could take
over seemlessly.
>You should talk to your hardware people and see what's
available.
>John
>.
>

No comments:

Post a Comment