Tag: SQL Server Availability Groups

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 Feature Was There All Along

SQL Server Availability Groups have been around for a while. But not a lot of organizations have implemented them yet mainly because they haven’t upgraded their database platforms to SQL Server 2012/2014. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much more common. And […]

When A Log Backup Does Not Truncate Your SQL Server Log Files In An Availability Group

[callout]This was one of the questions asked during my Monitoring SQL Server Availability Group webinar two weeks ago. If you want to get notified for upcoming webinars, be sure to sign up for my email newsletter.[/callout] There are only two ways that can truncate your SQL Server log files – a checkpoint process when the […]