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