SQL Server performance
Tuning SQL Server has a big bearing on how SharePoint will run as an application. This is the backbone of SharePoint and stores all data for the farm. There are outside configurations that help here, such as blob storage, which we talked about earlier in this section. The easiest way to gain performance on your databases is to follow these recommendations:
- Database maintenance
- Dual NICs to minimize traffic
- Isolate Search Indexing
When creating a maintenance plan, one of the key responsibilities is to make sure you have enough disk space to hold backups of the content you are managing in the SharePoint farm. If you do not have enough space, you will not be able to hold backups for all your databases. You also want to use cheap storage for this location, depending on the size of your content and services. If you have a large amount of data, then you may want to use faster writing disks.
When looking at the size of our databases, what could...