Tag: SQL Server Failover Clustered Instances

Reviewing the Windows Event Logs to Find Hints That Can Cause Availability Issues

SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases [callout]This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered […]

Reviewing the SQL Server Error Logs to Find the Two Most Common Keywords That Can Cause Availability Issues

SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases [callout]This blog post is the second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered instances and […]

Beyond Technical Reasons: Running a Single Instance or a Multi-Instance SQL Server Failover Cluster

When asked about best practices on running multiple SQL Server failover clustered instances (FCI) on a multi-node Windows Server Failover Cluster (WSFC,) a common response from SQL Server experts might include the following: appropriately allocating enough hardware resources on all of the nodes in the WSFC appropriately configuring maximum server memory settings per SQL Server FCI […]

An Underrated Feature: Cluster Shared Volumes (CSVs) with SQL Server Failover Clustered Instances

[callout]*My online course, Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA, is all about helping you become confident in deploying SQL Server workloads that run on top of a WSFC. This series of blog posts explores some of the lessons covered in the course. If you want to learn more about the […]