What is resource throttling in SharePoint?
The biggest performance bottleneck in SharePoint sites is caused usually by large lists. If you have 50 simultaneous users on a site and two of them are contributing to large lists, all 50 users will experience very slow performance. Luckily starting from SharePoint 2010, There is a feature called “Throttling” introduced to address this issue. Throttling defines the Maximum number of rows a user can query at a time.
The resource throttling feature in SharePoint is used to configure Threshold for large lists to prohibit operations that involve too many items, such as queries that return a large number of items or adding a column to a list that contains a large number of items. List throttling is turned on by default in SharePoint 2016 and the default value for List View Threshold is 5,000. When the number of items in a list exceeds this value, users receive a warning when they browse the List Settings page.
SharePoint Resource Throttling List View Threshold
Large lists are always performance killers in SharePoint. Any operation such as data retrieval, update, delete of more than 5000 rows results in an error message “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”. It sets the limits on the rows of data that can be retrieved from a SharePoint list or document library at one time, to optimize performance in SharePoint.
Throttling feature provides flexibility on User levels, say you want increase the threshold for Administrators. So, When someone runs the query to retrieve all items, the number of items returns will be determined by the throttling setting for the given list and the user rights.
How to Change Resource Throttling Threshold in SharePoint?
You can set the throttling settings via central admin.
- Central Administration > Application Management > Manage Web Application.
- Once in the Web Application List, select the web application and click General Settings > Resource throttling.
List throttling settings sets the limit on the row of data can be retrieved from a SharePoint List Views, also applies to queries executed by custom code.
Object Model Override
In most cases you will still need to access, read and modify some objects from the throttled resources. The object model override setting allows users with the appropriate permissions to be able to override the List View Threshold setting programmatically for specific queries. To set this, ensure that the Object Model Override option is set to “Yes”.
List View Threshold for Auditors and Administrators.
List View Threshold for Auditors and Administrators is set to the maximum number capable of showing all the content from SharePoint. The default value of 20,000 which you may need to fine-tune. Any operations that exceed this limit are prohibited.
Daily Time Window for Large Queries :
Now, set the daily time window for the rest of the users who will also need to access the throttled resources. This can be outside your working hours, so that most of the users will be offline. You can configure it under “Daily Time Window for Large Queries” setting. Typically, this setting is set outside of working hours to avoid excessive loads on the server, and is often referred to as “happy hour.”
List View Lookup Threshold: This feature limits the number of Lookup, Person/Group, or Workflow Status fields that a query can perform. It should not be greater than 8.
List Unique Permissions Threshold: This is the maximum number of unique permissions allowed per list or library.