Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

What's the Benefits of a Failover Cluster Instance

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

What's the Benefits of a Failover Cluster Instance

Postby chicagotech » Wed Aug 23, 2017 3:45 pm

Q: What's the Benefits of a Failover Cluster Instance

A: Quoted from Microsoft:
When a SQL Server instance is configured to be an FCI (instead of a standalone instance), the high availability of that SQL Server instance is protected by the presence of redundant nodes in the FCI. Only one of the nodes in the FCI owns the WSFC resource group at a time. In case of a failure (hardware failures, operating system failures, application or service failures), or a planned upgrade, the resource group ownership is moved to another WSFC node. This process is transparent to the client or application connecting to SQL Server and this minimize the downtime the application or clients experience during a failure. The following lists some key benefits that SQL Server failover cluster instances provide:

•Protection at the instance level through redundancy

•Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures)

•Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares.

•Disaster recovery solution using a multi-subnet FCI or running an FCI-hosted database inside an availability group. With the new multi-subnet support in Microsoft SQL Server 2012, a multi-subnet FCI no longer requires a virtual LAN, increasing the manageability and security of a multi-subnet FCI.

•Zero reconfiguration of applications and clients during failovers

•Flexible failover policy for granular trigger events for automatic failovers

•Reliable failovers through periodic and detailed health detection using dedicated and persisted connections

•Configurability and predictability in failover time through indirect background checkpoints

•Throttled resource usage during failovers
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6920
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 3 guests