Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

multiple instance failover solution Expand / Collapse
Author
Message
Posted Friday, April 26, 2013 9:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
I need to create a solution for a mutl instance (needed by 3rd party app) 2012 failover solution. I will have 2 physical high end servers (128 gig of RAM), plenty of CPU power. It will be implemented on Standard edition (could possibly change that) 1st thought was an simple active passive cluster (I am assuming you can do this with the multiple instances?). ANy other ideas on a novel approach?


Post #1447057
Posted Friday, April 26, 2013 9:34 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 4,351, Visits: 6,166
timscronin (4/26/2013)
I need to create a solution for a mutl instance (needed by 3rd party app) 2012 failover solution. I will have 2 physical high end servers (128 gig of RAM), plenty of CPU power. It will be implemented on Standard edition (could possibly change that) 1st thought was an simple active passive cluster (I am assuming you can do this with the multiple instances?). ANy other ideas on a novel approach?


Multi-instance cluster works fine AFAIK. You may also want to look at database mirroring, which can be better than clustering in some ways. I note that on Std Ed you can only do synchronous mirroring, but with fast hardware and network it scales pretty well.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1447066
Posted Friday, April 26, 2013 1:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 12:52 PM
Points: 502, Visits: 750
we actually have a 3rd party app that simulates the mirroring so I am looking at the active passive solution


Post #1447132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse