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 […]
With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing and managing it has become a lot easier. I started doing my Gone Clustering in 60 Minutes presentation back in 2010. And I’m still amazed at how much it has improved. But I still talk about the frustrating hardware compatibility […]
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 first in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
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 […]
This week, I had the amazing opportunity to do a webcast for the PASS High Availability and Disaster Recovery Virtual Chapter covering the five things that you need to consider when deploying SQL Server Failover Clustered Instances (FCI) and Availability Group (AG) replicas in a Disaster Recovery Site. I’ve written several blog posts about this topic and […]
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 […]
The Windows Server Failover Clustering for the Smart SQL Server DBA course was created in an attempt to help SQL Server DBAs and server administrators responsible for SQL Server Failover Clustered Instances (FCI) become more confident in what they do. This idea dawned on me as I was talking to customers who are unnecessarily spending money on hardware that […]
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 […]
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.
