By default, each SharePoint web application uses only one content database ). As the number of website sets created in this web application increases, or the number of website data sets increases, the content database is also increasing.
To adapt to the growth of data and maintain performance, administrators can create more content databases for a Web application as needed. In "Application Management-content database" in the SharePoint management center, the administrator can create a new content database after selecting a web application:
By specifying the new content database to different SQL Server physical servers, You can distribute the content database used by the new website set to different servers when creating a new website set, achieve load balancing.
When a web application has multiple Content databases, the last created content database is used by default to host the new website set. If you want to specify a specific content database to host the new website set, you can change the status of other content databases to "offline. "Offline" does not mean that the content database is not available, but does not need it to host the new website set.
At the same time, you can make full use of the Partition Function (partition) of Microsoft SQL Server 2005 to partition data physically.