Infrastructure at your Service

Tag

Failover cluster Archives - Page 2 of 2 - Blog dbi services

Microsoft Team

SQL Server 2016 : availability groups with no domain dependencies

By | Database Administration & Monitoring | No Comments

Are you aware about the new features of the next Windows version? Currently we’re in TP3 and during my investigation, I was very happy to see the new features for Windows clustering (cf. this blog post from Microsoft). By reading this article we can see: Workgroup Clusters: Clusters with nodes which are member servers / workgroup (not domain joined) If you remember, Microsoft had introduced Active Directory-Detached Cluster feature with Windows 2012 but the dependency…

Read More
Microsoft Team

SQL Server 2014: FCIs, availability groups, and TCP port conflict issues

By | Operation systems | One Comment

After giving my session about SQL Server AlwaysOn and availability groups at the last French event “Les journées SQL Server 2014”, I had several questions concerning the port conflict issues, particularly the differences that exist between FCIs and availability groups (AAGs) on this subject. In fact, in both cases, we may have port conflicts depending on which components that are installed on each cluster node. Fundamentally, FCIs and AAGs are both clustered-based features but each…

Read More
Microsoft Team

WSFC : Manual or automatic failover? That is the question!

By | Hardware & Storage | 2 Comments

During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details … So keep quiet and after connecting to your environment you are not able to find anything … What was happen? Maybe someone has triggered manually a failover and you are not aware of it. I’m…

Read More
Microsoft Team

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

By | Operation systems | No Comments

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people. Since we therefore lack practice, I have to admit that we do not always know the good configuration settings to apply to the virtualized layer in order to correctly run our SQL Server FCI architecture. A…

Read More