Making Sense of the Windows Server Failover Cluster Debug Logs For Mere Mortals

Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 5

In part 4 of this series, I talked about how to generate the cluster debug log for digging deeper on what caused the WSFC or the workloads running on top of it to go offline. I also walked you thru the process of getting started with reading the logs. Analyzing the cluster debug log is […]

Generating the Windows Server Failover Cluster Debug Logs

Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 4

I started this blog post with a warning mainly because I’ve seen a lot of engineers and database administrators spend so much time figuring out the root cause of why a SQL Server database running on a WSFC is offline – while it is still offline. I know because I used to be like that. […]

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

Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 2

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   As I was driving out of my driveway, I noticed something that is considered to be every car owner’s worst nightmare: the […]

Exploring The Windows Server Failover Cluster Dependency Report

Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 1

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 Renting a car is something that I do quite frequently as I travel. Different rental car companies have a variety of car models […]