Generating the Windows Server Failover Cluster Debug Logs

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

get-clusterlog

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 Windows Event Logs to Find Hints That Can Cause Availability Issues

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

eventlogfiltered

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 In the first blog post in this series, I talked about how to use the Cluster Dependency Report to identify the potential […]

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

check-engine-light

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 […]

Have You Invested In This?

twitter1

A week before I officially launched my online course How to Build a Personal Lab for Deploying SQL Server on Windows Server Failover Clusters, I asked this question on Twitter. There were various responses, ranging from “very important” to “it helped my career“. While reading one of the responses, I realized that I actually asked the wrong question. […]

The Biggest Challenge I Had in Mastering Windows Server Failover Clustering for SQL Server

roadblock-512

Last July, I launched my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA. The course took a year-and-a-half in the making. But mastering the concepts I covered in the course took over a decade. With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing […]