Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Databases used by SharePoint have fragmented indices (SharePoint Foundation 2010)

SharePoint 2010

Published: July 8, 2010

Rule Name:   Databases used by SharePoint have fragmented indices

Summary:   Microsoft SharePoint Server 2010 uses Microsoft SQL Server to store most of the content for the Web site and configuration settings. One or more of the databases used by SharePoint Server have fragmented indexes. A fragmented index can cause degradation in performance.

Cause:   Database indexes can fragment over time as a result of insert and update operations performed by SharePoint Server. We recommend that you periodically delete and rebuild these indexes to improve system performance.

Resolution:   Reorganize and rebuild indexes

  1. To correct index fragmentation, you can reorganize an index or rebuild an index. For information, see Reorganizing and Rebuilding Indexes (http://go.microsoft.com/fwlink/p/?LinkID=160083&clcid=0x409).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.