This is a nice video by Brent Ozar on AlwaysOn Availability Groups: Real-Life Lessons Learned.
In this video, Brent explains what is ‘AlwaysOn’, AlwaysOn Availability Groups and the way that they work. AlwaysOn Failover Clustering is exactly the same as the Failover clustering but AlwaysOn Availability Groups is different – requires SQL 2012 Enterprise.
Brent talks about issues with hotfixes and keeping on top of them and real life Microsoft support issues.
Lessons learned on Windows Setup, Quorum Backups and Monitoring.
Note – this blog post has a title ‘best practices’. I named it so to match the referred TechNet article entitled “Best practices for SQL Server in a SharePoint Server farm”. So please forgive me for using the term ‘best practices’. Probably ‘guidelines’ or ‘good practices’ is a better name for this article.
Getting back to the topic: Some times you need a refresher when it comes to guidelines in setting up SQL for SharePoint – especially when setting up the newer SharePoint 2013.
There is a Technet article I would like to refer to here which specifically refers to ‘best practices’ for SQL server in a SharePoint 2013 environment. There are a few changes to note when it comes to SharePoint 2013.
A couple of important things to note:
Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server.
Set the MAXDOP (max degree of parallelism) setting to 1 and nothing else. Setting the max degree of parallelism to any other number can cause a less optimal query plan to be used that will decrease SharePoint Server 2013 performance.
There is also some guidance on setting up the SQL instance for better performance and managing the SharePoint databases.
Here’s the article for further reading:
Some time ago, I was collecting some Backup & Restore best practices for SharePoint and I came across this post.
It talks about various aspects of backup and restore for a SharePoint farm. Its based on SharePoint 2010 but can be applied to SharePoint 2013.
- IIS Configurations required in a Disaster Recovery
- Backup Scenarios
- Restore Scenarios
- SQL Backup maintenance plans
- Overview of monitoring with SCOM (System Center Operations Manager)
- DPM (System Center Data Protection Manager)
Worth a look: http://blogs.technet.com/b/surama/archive/2012/05/29/sharepoint-2010-backup-and-restore-best-practices.aspx
When installing SharePoint, a good practice is to use SQL Aliases for your installation.
To manage and create a SQL Alias via a gui tool, go to start > run > cliconfg and Enter. Then go to the Alias tab. Continue reading
In this article, we will discuss a few things to have you installing Reporting Services 2008 R2 with SharePoint 2010 in ‘SharePoint Integrated mode’ – not NATIVE mode using a config file for the SQL set up (Reporting Services is a SQL product) and also integrating Reporting Services with SharePoint (the Central Admin stuff). Continue reading
This link is an good list of ‘good’ practice points that a SharePoint Admin can discuss with your DBA.
You might have most in place due to the abundance of information online, but its worth a refresher..
A good practice is to move IIS off the system drive to another such as D:
Ok, so you tell your Server guys but they miss out on an important step such as updating the registry to the new D:\inetpub… location. You dont check this since you think they know what they are doing and go ahead and install SharePoint and once you are done, you realise that your Central Admin website has been installed and its virtual directory is located on C: – the system drive.
This is a reminder for SharePoint Admins, DBAs and Developers to ensure that they have taken the necessary steps recommended by Microsoft when it comes down to SharePoint 2010 database maintenance.
A few years ago, I posted out a similar ‘reminder’ for SharePoint (MOSS) 2007. http://www.jeremytaylor.net/2009/09/07/sharepoint-database-maintenance
More recently, last year, Microsoft (Bill Baer and Bryan Porter) published a document on SharePoint 2010 database maintenance. Continue reading to get a summary of what is involved in maintaining databases for SharePoint 2010…
Ever wondered if there is a formula for calculating content database sizes? Want to have a start into learning more about SQL design and database capacity planning for SharePoint 2010?
Luckily, there is an awesome Technet document on SQL server design and capacity planning and it covers some great points to consider when planning your storage with SharePoint 2010.
When planning SharePoint environments in a fully virtualised environment, a very relevant (and appropriate) question to ask is… “Is Microsoft SQL Server clustering supported on VMware?”
Its time to look at some links that I came across that might be handy for you in future. You could bookmark this page, so you can add it to your ‘To Read’ list.
Is Microsoft SQL Server clustering supported on VMware?
Yes! Continue reading