Frozen SharePoint PSConfig Upgrade with SQL Server AlwaysOn

If you have a SharePoint farm that uses SQL Server AlwaysOn and your upgrade is just never finishing, this article might be for you. Update: as someone pointed out, removing the service-application from the farm probably isn’t necessary. Just remove the DB from the AlwaysOn availability group and then the upgrade should just work. When…


AlwaysOn Asynchronous vs Synchronous Commit Performance for SharePoint

Hot on the heels of the last analysis showing the performance hit for a synchronous SQL Server AlwaysOn cluster, re-running the same tests show a distinct performance boost when asynchronous commits are used. In fact it’s nearly the same as standalone at that point, which makes sense as DB updates aren’t restricted to needing confirmation…


SharePoint & SQL Server AlwaysOn vs Standalone Performance

How to setup SharePoint with SQL Server AlwaysOn has been covered nicely now, but I’ve not covered the performance hit setting up such a system will incur. The short version is: updates are about x2 slower than standalone for a x2 node AlwaysOn cluster; reading data is about the same performance (which would make sense)….


SharePoint 2013 on SQL Server AlwaysOn, 2014 Edition

SQL Server 2014 is out bringing with it enhanced AlwaysOn clustering, and is indeed already supported by SharePoint 2013 with at least the SharePoint 2013 May 2014 cumulative update installed. Some new benefits in SQL Server 2014 are the reliability improvements for when connectivity is lost between nodes and also the ability to add a SQL…


Building True Multi-Subnet Windows Server Failover Clusters

Something you may have heard of if you know clustering at all is the idea of “multi-subnet clusters”; a capability introduced in Windows Server 2012 (if memory serves) to Windows Failover Clustering. It’s conceptually the same thing as a normal cluster; it’s designed to withstand an instance failure but multi-subnet clusters allow us to withstand…


SharePoint 2013 and SQL Server AlwaysOn – High Availability SharePoint

What is AlwaysOn and why use it for SharePoint? Update: SQL 2014 + SharePoint 2013 (abridged) guide also available. Also if you want to use AlwaysOn for SharePoint Disaster Recovery, then you’ll want to have a look at this article – AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients…