Category Archives: SQL Server

Posted on

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

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

Posted on

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

Posted on

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

Posted on

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

Posted on

Who Says Quotas Are Only For Sales

When Active Directory Quotas Prevent The Creation of SQL Server Failover Clustered Instances and Availability Groups

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