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.
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.
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
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