Thursday, October 12, 2017

High Availability in SharePoint

As we become more dependent on SharePoint, how do we keep it online always?  SQL must first be online.  Here is more to help.

AlwaysOn

Brents take on Always On
http://brentozar.com/go/alwayson

Detailed steps to configure an AlwaysOn Availability Group for SharePoint
http://technet.microsoft.com/en-us/library/jj715261.aspx

SharePoint 2013 and SQL Server AlwaysOn - High Availability SharePoint
http://blogs.msdn.com/b/sambetts/archive/2013/04/24/sharepoint-2013-and-sql-server-alwayson-high-availability-sharepoint.aspx

SQL 2012 AlwaysOn Availability Groups for SharePoint 2013 - SharePoint Connections Amsterdam 2012
http://www.slideshare.net/michaeltnoel/sql-2012-alwayson-availability-groups-for-sharepoint-2013-sharepoint-connections-amsterdam-2012

SQL Clusters

Many thinks from Brent Ozar … thx brent and kendra

Introduction to SQL Server Clusters (2012)
https://www.brentozar.com/archive/2012/02/introduction-sql-server-clusters/

Why doesn’t SQL Server always share memory well with other applications? Well, not all applications share memory in ways that work well with it! More information is here: http://msdn.microsoft.com/en-us/library/ms177455.aspx

Brent did a great webcast comparing disaster recovery options. He gives an overview of different methods along with pros and cons of each one. Check it out here: https://www.brentozar.com/archive/2011/12/sql-server-high-availability-disaster-recovery-basics-webcast/

Can you explain a little more on your reluctance to cluster a virtualized server?  “Why Your SQL Server Cluster Shouldn’t Be Virtualized” https://www.brentozar.com/archive/2012/09/why-your-sql-server-cluster-shouldnt-be-virtualized/

Excellent three part series on cluster network communication in Server 2008 by Chuck Timon: http://blogs.technet.com/b/askcore/archive/2010/02/12/windows-server-2008-failover-clusters-networking-part-1.aspx

Everything You Know About Clustering is Wrong
https://www.brentozar.com/archive/2012/06/everything-know-about-clustering-wrong/

very tricky to make SSIS highly available. Here’s a blog post explaining the challenges and one workaround here:
http://blogs.technet.com/b/andrew/archive/2008/11/28/high-availability-integration-services-in-sql-server.aspx

Want more info? See “Running multiple instances of SQL Server” here– it’s not specific to clustering but the same info applies: http://msdn.microsoft.com/en-us/library/ms178067.aspx. Note that the article lists three approaches, and I am recommending the second one, which lets you get the most bang for your buck, but I do still recommend setting max memory.

These properties are one of the interesting things about working with clusters. Check out Books Online here: http://msdn.microsoft.com/en-us/library/ms174396.aspx

Microsoft has published some general requirements for failover clustering hardware: http://technet.microsoft.com/en-us/library/jj612869.aspx

First start by checking out our explanations of the different recovery technologies at https://www.brentozar.com/go/fail and there’s resources for each one.

https://www.brentozar.com/sql/sql-server-failover-cluster/

high availability planning worksheet: https://www.brentozar.com/archive/2014/05/new-high-availability-planning-worksheet/

Brent’s video on licensing here: https://www.brentozar.com/archive/2014/09/how-sql-server-licensing-works/

https://www.brentozar.com/archive/2015/06/how-to-set-up-standard-edition-alwayson-availability-groups-in-sql-server-2016/

How to install and fail over your clustered instance
https://technet.microsoft.com/en-us/library/ms189134%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

Resources

https://www.brentozar.com/responder/

Technet
http://technet.microsoft.com/en-us/library/cc748824.aspx

Great SQL Resource
http://dba.stackexchange.com.

Third Party Solutions
http://sharepointgalaxy.blogspot.com/search/label/vendor

1 comment:

  1. windows server 2008 standard Edition taking on the bulk of network services, the Enterprise Edition is really focused on server systems that require extremely large-scale processing and memory capabilities as well as clustering or Active Directory Federation Services

    ReplyDelete