Making SQL sense

+44 (0)20 3051 3595 info@coeo.com

The Coeo Blog

Is this the end of SQL Server Failover Cluster Instances?

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..

Using an Azure cloud witness in your failover cluster

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.

Why you should always configure a quorum witness on a failover cluster

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..

Clustering SQL Server 2008 R2 on Windows Server 2012 R2

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.

The curious case of the slowly starting cluster

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..

SCOM Won't Discover My SQL Server (Or Cluster)

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..

UPDATED: Windows Server 2012 Failover Clustering

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.

Implementing a SQL Server 2012 failover cluster instance on Windows Server 2012, in January 2013

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..

Back to top