Regarding High Availability for a 3TB Data environment

Hi guys,

A client of ours has about 70 MS SQL databases on a bunch of single servers running. The client wants to consolidate all those databases into 1 large database. Data wise, we are talking about 3 TB. The client insists High Availability as the data is critical.

I've setup a couple of clusters [Active\Passive] in the past, but I don't know if that's the right choice in this case.

The Client suggested to run the database on 2 or 3 instances. As I'm someone who is specialized in Oracle. I thought that was the main difference with Oracle, that it's not possible to run a database on several instances with MS SQL.

I'd love your intake on this one.
more ▼

asked Jan 26, 2012 at 11:43 AM in Default

Freddy gravatar image

36 2 2 4

(comments are locked)
10|1200 characters needed characters left

6 answers: sort oldest
i think, Log-shipping is not a better choice. as mirroring does better that Log-shipping. I would recommend you to set up cluster for database access availability. Mirroring, replication would cater for disaster recovery. for performance, you can use RAID 10. number of spindles, enough RAM, proper configuration of RAM, Indexing and stats, regular maintenance.
more ▼

answered Feb 03, 2012 at 03:05 PM

Zahid gravatar image

91 9 10 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 26, 2012 at 11:43 AM

Seen: 1818 times

Last Updated: Feb 03, 2012 at 03:09 PM