SharePoint® 2010 Business Intelligence 24-Hour Trainer

27

Managing and Optimizing SharePoint SQL Server Databases

When you install SharePoint Server 2010 Enterprise Edition, you will start with several SQL Server databases. Most of the databases will be suffixed with a system-generated GUID. These names can be changed, but that is a book within itself. This lesson provides an overview of the different databases, a brief explanation of what is stored in most of the databases, and provides a few techniques that can be used to optimize each database type.

OVERVIEW OF SHAREPOINT 2010 DATABASES

As mentioned earlier, when SharePoint is installed several databases are created. Each database contains data that is specific to a certain area of SharePoint 2010. In some cases there will be more than one of the same type of database, but it will be suffixed with a different GUID. Figure 27-1 lists the databases that will be created after a default farm install.

The database model in SharePoint 2010 has been modified significantly. Instead of storing all content in a few large tables, the data is stored in different tables. This change allows several people to work on large projects without creating contention on the SQL Server.

SharePoint 2010 also introduced a few new databases. Whenever you configure a new service, a new database is created. For example, when you configure the Secure Store Service and PerformancePoint Service Application, two corresponding databases are created, as shown in Figure 27-2.

FIGURE 27-1

FIGURE 27-2

In addition, ...