SQL Server Memory

Determine whether the min server memory and max server memory settings have been changed in your SQL Server configuration options. Ensure that SQL Server does not release memory below the configured minimum server memory once that threshold is reached.

Read more

DB Servers Hotfixes

All components in a SharePoint environment, including SQL servers, should be on the same patch level. Read more to see how you can verify installed Windows and SQL Server updates.

Read more

Loopback Disabled

Authentication will fail if the FQDN or the custom host header of the SharePoint web application does not match the local computer name. Read more to see how you can disable the loopback and make sure your SharePoint is working properly.

Read more

ModelDB Recovery Model

The model database is used as the template for all databases created on an instance of SQL Server. There are three database recovery models in SQL server – Simple, Full and Bulk logged. Read more to see how you can set the recovery model according to our recommendations.

Read more

TempDB Response Times

If you are experiencing performance issues, you might want to check whether the tempdb database files are stored on dedicated drives. Read more to see how you can check this.

Read more

Content Database Capacity

As the size and the configuration of a Content Database can have an impact to the performance of the system, you should not allow content databases to grow beyond 200 GB. Read more to see our recommendations and guidelines on how to set the database initial size and auto-growth size.

Read more

SQL Alias

If you are moving databases between different SQL servers or trying to scale out the SharePoint environment, aliases can be very useful. Our recommendation is to group the databases based on the usage and purpose, and define the aliases based on that. Click here to see an example of database distribution and grouping.

Read more

Max Degree Of Parallelism

If the MAXDOP value has not been set to 1 on the SQL server instance on which you’re attempting to host your SharePoint 2013 databases, you will not be able to create databases on the instance. Read more to see how you can set it properly.

Read more

ModelDB Files Initial Size

The exact value of your ModelDB files will depend on the amount of data, available disk space and (expected) number of content databases and other factors. For example, if you expect your SharePoint farm to host a small amount of data, you could go with 500 MB or 1 GB as an initial size.

Read more