Category: SQL Server

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

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

I’m re-launching 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 and managing it has […]

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

Who Says Quotas Are Only For Sales

Ever since I started working on projects involving SQL Server Availability Groups back in 2012, the most common issues I’ve come across with have nothing to do with SQL Server. After my presentation on Architecting SQL Server Availability Groups at the Seacoast SQL Server User Group in New Hampshire, someone approached me to share a […]