Build on SharePoint
The blog of Sam Betts on SharePoint application development - full of lot's of useful info, guides, and various cats.
Translate This Page
Translate this page
Office Web Apps
Browse by Tags
Build on SharePoint
Tagged Content List
Combining Disaster Recovery Farms with SQL Redundancy for SharePoint with SQL Server AlwaysOn
Alternative title: “ how do I get a redundant SQL backend combined with a disaster recovery site, using AlwaysOn ”? This is a question that has come up a bit just recently so I though I'd clarify how this can work. Arranging the SQL Server AlwaysOn setup for SharePoint, especially when...
20 Jan 2016
SharePoint Usage Database in SQL Server AlwaysOn
SharePoint has a very handy service-application that’s normally running called the “SharePoint usage & health” application. It’s actually a very useful to have under normal circumstance as it logs pretty much everything you could ever want to know about the operational health of the SharePoint farm;...
23 Oct 2015
Introduction to Running Disaster-Recovery/Hot-Standby SharePoint Farms
So you’ve heard about the possibility of running two SharePoint farms in parallel to help keep SharePoint users happily online longer, and you want some more information about how it works and why you’d want it. This one is a nice and quick post on just the basics to sell the idea a bit - nothing too...
9 Sep 2015
Patching SharePoint with No Downtime using SQL Server AlwaysOn
As highlighted in a previous post , it is perfectly possible to patch SharePoint without suffering any downtime at all if you have x2 SharePoint farms to play with. This is great if you’re worried about the update process taking either too long for a maintenance window or not completing at all...
20 Aug 2015
Setting up SharePoint Disaster Recovery Sites with SQL Server AlwaysOn
Something I’ve been promoting as an essential high-availability strategy for SharePoint for a while now is having a Disaster Recovery (DR) site for SharePoint. A SharePoint DR site is simply an entirely separate SharePoint farm that uses a copy of the content data in case the first farm runs into...
24 Apr 2015
SharePoint + SQL Server AlwaysOn: Outage Troubleshooting
So you have a SharePoint/SQL outage despite having SQL Server AlwaysOn configured, and you naturally want to know why. Event IDs 5586 and 6398 are flooding the SharePoint servers and you don’t know why. On the SharePoint servers in the application log you might see either this: Unknown SQL Exception...
12 Dec 2014
SharePoint & SQL Server AlwaysOn Failovers – Video Demonstration
To demonstrate how SharePoint and SQL Server AlwaysOn work together, especially with a failover, I did a quick video to show it in action. Here it is, enjoy ( https://www.youtube.com/watch?v=se_M1vdriMA if the embedded video doesn’t load): SharePoint 2013 with SQL Server AlwaysOn SQL Server AlwaysOn...
20 Oct 2014
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...
22 Aug 2014
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...
21 Aug 2014
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...
20 Aug 2014
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...
16 May 2014
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...
16 May 2014
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 - http://blogs.msdn.com/b/sambetts/archive/2015/04/24/setting-up...
24 Apr 2013
Page 1 of 1 (13 items)
© 2015 Microsoft Corporation.
Privacy & Cookies