Build on SharePoint

The blog of Sam Betts on SharePoint application development - full of lot's of useful info, guides, and various cats.

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 past SP1. 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 Server instance hosted...
  • Blog Post: 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...
  • Blog Post: 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 . AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients to have a mirroring and failover database solution all transparently for a single named instance...
Page 1 of 1 (8 items)