Resource throttling is configuration for performance of
lists and resource contention. Resource throttling allows SharePoint Admins to
manage the heavy data in SharePoint lists. From SharePoint lists supports
millions of items, to control the data like number of items to retrieve at a
time and number of items in a view we have Resource throttling configuration in
SharePoint.
To configure resource throttling in SharePoint, Navigate to
Manage web application SharePoint Central Administration. Select web
application, in ribbon click on General settings drop down, select Resource
throttling option.
In Resource throttling window,
List view Threshold value specifies the maximum number of
items retrieved in one request. If the operation exceeds that value will be
blocked. This limits the queries in the list, so that the performance will be
increased. Default value is 5000.
Allow object model override, allows us to perform queries
programmatically request the query use of higher List View threshold. This will
be helpful in a using custom code and need to override list value threshold.
Default value is “Yes”.
List View Threshold for auditors and administrators mentions
the maximum number of items from DB query to process at one time when performed
by auditor or administrator permissions. This will work in conjunction with
“Allow Object Model Override”. By default this value is 20000.
List View Lookup Threshold value will specify the maximum
number of join operations based on the lookup, Person/Group, workflow columns.
Default value is 8. If Query uses more than 8 column values, operation will be
blocked.
“Daily Time Window for Large Queries” allow us to specify run
the large queries in day when usage is low. By specifying the time System will
run the large queries with not enforcing the list throttling limits.
By using “List Unique Permissions Threshold” value, we can
specify the minimum number of unique permissions that a list/library can have.
By default it is 50000.
By selecting “On” for backward compatible Event handlers option
SharePoint lists/libraries will supports for backward compatible events. By
Turning on HTTP Request Monitoring And Throttling, a job will monitor
performance of the front-end web server.
