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.