One of the common customer queries we get at Coeo is how to provide high availability for SQL Server. I have been advocating the use of SQL Server Failover Cluster Instances (FCI) to provide high availability for over 10 years. However, during a review of our reference architecture the question..
I’ve blogged previously about the need to configure a quorum witness on failover clusters and now with Windows Server 2016 there’s a great new quorum option – a cloud witness.
Since Window Server 2008, the role of what we used to call the “Quorum Disk” in a Failover Cluster has changed significantly and it’s now referred to as a “witness” because its only job is to help the nodes in the cluster decide who should be running the cluster resources in the event that they..
I recently had to install a SQL Server 2008 R2 failover cluster on Windows Server 2012 R2. Some of you may be wondering if this is actually supported. A quick look at the hardware and software requirements for SQL Server 2008 R2 indicates that it is indeed supported.
I came across an interesting case today that I thought it was worth doing a quick blog post about. I was working with a customer who was migrating onto their newly built SQL Server 2014 clustered instance. Part of the pre-migration testing was to fail the SQL Server service between the two nodes to..
In my previous post I discussed an instance where SCOM was failing to monitor the space of a SQL Server database. In this latest post I want to bring to light an issue that was altogether more serious.
I particularly wanted to write this post because, although there are a number of possible..
Back in January, I wrote a blog article about some issues I faced when installing SQL Server 2012 failover cluster instances on Windows Server 2012, it’s available here.
August 2013 Update : I’ve since written about updates on this subject here
New and Improved
I’ve been using Windows Server 2012 for a while now, not just because it’s the newest and shiniest Microsoft operating system, but also because some of its new features are useful to me as both an..