SQL Server 2008 infrastructure

By sandeepmurthy ·

I am designing an infrastructure to host a high availability SQL Server 2008 database. Since the requisite is too build a cheapest possible high availability structure, I am thinking of a Synchronous Mirrored database since both the databases (Principal and Mirror) will be located in the same datacenter and do not foresee any bandwidth issues and have only One database to host.

The specifications are as follows:
Load: 500 simulaneous users and upto 2000 users per day; RTO 2 hrs and RPO 6 hours.

What I have come up with is the following:
The OS would be a 64 bit Windows Server 2008 and the database shall be hosted on a virtualized platform, Intel Itanium 1.66 GHz (or Intel Pentium IV with EM64T support), 8 Gb RAM.

Does this seem as a acceptable infrastructure? I have heard that Virtualization has a negative impact on Performance. TO what extent is this true? What are the pros and cons here?

The client has stressed on cheaper solutions so may be Itanium servers are not right... Appreciate any alternatives!

I have discarted Cluster as an alternative because of the increase in cost.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums