The default installation of SharePoint uses WMSDE as the data engine for the content and configuration databases. WMSDE runs locally on the server and limits the total size of SharePoint sites to 2 GB per content database. However, WMSDE does not limit performance, which is a change from previous versions of the data engine. Upgrading from WMSDE to SQL 2000 (SP3a) on a shared server increases the capacity of SharePoint sites and simplifies maintenance since you can use SQL Server Enterprise Manager to configure automated back-ups and perform other tasks . Upgrading the databases to a dedicated server running SQL 2000 can significantly improve performance as well as capacity, particularly for high-volume sites. If you install SQL 2000 on a shared server after installing SharePoint, setup should upgrade the WSMDE server instance to use SQL 2000. To verify the data engine used by a server instance:
|