As a SharePoint Consultant I get to see dozens of SharePoint farms every year, and one of the most common complaints I get from clients – is that SharePoint is slow. A lot of people think that SharePoint is slow because the SharePoint servers are lacking resources or, simply, because SharePoint is a slow product. Although resources allocated to the SharePoint servers (e.g. Web Front Ends and App servers) are important, not a lot of people realize that SharePoint performance is directly related to the database, SQL Server. In fact, 94% of SharePoint data is stored in SQL.
In this section we will review important best practices on how to format your disks, as well as how to plan where databases, logs and your Temp DB will be located. Furthermore, depending on the purpose of your SharePoint 2013 Farm, we will determine which databases are most important.
How to install SQL Server 2012
Now that you installed SharePoint 2013, Web Applications are starting to be created, content is added. Unfortunately, if you want to keep your SharePoint fast and your users happy, your job is not done. In this section we will make a list of things you need to check and modify, together with a schedule. Luckily, since we made things right in the Post Installation changes, you won’t have to do them very often.