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 […]
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 […]
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 This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
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 This blog post is the second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC) for high availability. Understanding how the underlying WSFC platform works can help us maintain availability of our databases This blog post is the first in a series that talks about the process that I follow when troubleshooting availability […]
Ever since I started working on projects involving SQL Server Always On 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 […]
When asked about best practices on running multiple SQL Server failover clustered instances (FCI) on a multi-node Windows Server Failover Cluster (WSFC,) a common response from SQL Server experts might include the following: – appropriately allocating enough hardware resources on all of the nodes in the WSFC – appropriately configuring maximum server memory settings […]
And the registration is now OPEN! I’m excited to re-open limited-time registration for my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA course. Head on over to the main site. Registration for this course will only be available from 23-October 10:00 AM Eastern time to 29-October-2017 10:00 PM Eastern time. After that, you […]
While working on the video ad for my SQL Server Always On Availability Group: The Senior DBA’s Ultimate Field Guide training program, I couldn’t help but take stock of the different skills I had acquired throughout my lifetime to come up with the final result. – started playing piano at 5 – learned how to […]
I’ll never forget a conversation I had with a customer several years ago. I was asked to join a conference call to discuss a new SharePoint 2013 farm deployment. My involvement was limited to designing and deploying a SQL Server 2012 Availability Group for all of their environments – a different vendor was engaged to […]
