What is resource throttling in SharePoint?
The biggest performance bottleneck in SharePoint sites is usually caused by large lists. If you have 50 simultaneous users on a site and two of them contribute to large lists, all 50 users will experience very slow performance. Luckily, starting from SharePoint 2010, a feature called “Throttling” was 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 a 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 browsing 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.
The throttling feature provides flexibility on User levels, say you want to increase the threshold for Administrators. So, When someone runs the query to retrieve all items, the number of items returned 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 set the limit on the row of data that 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 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 the “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 Lookups, Person/Group, or Workflow Status fields that a query can perform. It should not be greater than 8.
List Unique Permissions Threshold: The maximum number of unique permissions allowed per list or library.