SharePoint performance degradation with a large number of unique security scopes in lists

Article ID: 2420771 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Performance degradation of Microsoft Office SharePoint Server 2007 and SharePoint 2010 with a large number of unique security scope set on folders or documents on a list.

CAUSE

SharePoint 2007:
When more than 1,000 security scopes are created for folders or documents in a list, there’s a significant performance degradation in SharePoint operations that badly affects end users operations(rendering content) as well as SharePoint activities like indexing SharePoint Content.  After the number of unique security scopes exceeds1,000 per list, SharePoint uses a code path that requires additional SQL round trips to analyze the scopes before rendering a view. When there are 1000 or fewer scopes, only one round trip is required. 

SharePoint 2010:
When a greater number of unique security scopes than the value of the List Query Size Threshold (default is 5,000) set to the web application are created for folders or documents in a list, there’s a significant performance degradation in SharePoint operations that badly affects end users operations(rendering content) as well as SharePoint activities like indexing SharePoint Content. After the number of unique security scopes exceeds the value of the List Query Size Threshold, SharePoint uses a code path that requires additional SQL round trips to analyze the scopes before rendering a view.

RESOLUTION

SharePoint 2007:
Control the number of unique security scopes for a list to be 1,000 or less.

SharePoint 2010:
Control the number of unique security scopes for a list to be less than the value of the List Query Size Threshold.

MORE INFORMATION

The links to the related Technet articles are here:

Plan for software boundaries (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc262787(office.12).aspx

Plan for software boundaries (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc287790(office.12).aspx

SharePoint Server 2010 capacity management: Software boundaries and limits
http://technet.microsoft.com/en-us/library/cc262787.aspx

Understand permissions and permission levels (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc262118(office.12).aspx

Understand permissions and permission levels (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc287792(office.12).aspx

Understand permissions and permission levels (Project Server)
http://technet.microsoft.com/en-us/library/cc197535(office.12).aspx


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2420771 - Last Review: October 13, 2010 - Revision: 4.0
APPLIES TO
  • Microsoft Office SharePoint Server 2007
  • Microsoft SharePoint Foundation 2010
  • Microsoft SharePoint Server 2010
  • Microsoft Windows SharePoint Services 3.0
Keywords: 
KB2420771

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com