Tag: troubleshooting

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

[callout]WARNING: If you’ve gone thru part 1, part 2 and part 3 of this series of blog posts and your SQL Server databases running on a Windows Server Failover Cluster (WSFC) are still offline and unavailable, I would recommend escalating it to a more senior engineer or calling Microsoft support before reading further. Regardless of […]

Generating the Windows Server Failover Cluster Debug Logs

[callout]WARNING: If you’ve gone thru part 1, part 2 and part 3 of this series of blog posts and your SQL Server databases running on a Windows Server Failover Cluster (WSFC) are still offline and unavailable, I would recommend escalating it to a more senior engineer or calling Microsoft support before reading further. Regardless of […]

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

Exploring The Windows Server Failover Cluster Dependency Report

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 first in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered […]