Configure resource restrictions in the SharePoint Management Center (large list)

The configuration of resource limits (large list) in the SharePoint Management Center is the core of SharePoint. Everything in SharePoint is a list. It can be said that SharePoint content is list-driven. The disadvantage of SharePoint in earlier versions is that when more than 2000 items are listed, the performance will be degraded. This does not mean that if the list contains 2001 items, the performance degradation will be obvious. A SharePoint list can contain millions of records. Let's break down what happened to the user request list. When you click the link to view the list items, it calls the query and returns the SQL statement to extract these items and present them. Check the number of columns in the list and perform a select all operation. The more items in the list, the more data is returned. The longer it takes to select all data, because it is the number of rows multiplied by the number of columns. A resource threshold value is a series of configurations built in software to handle large lists and resource disputes. The goal is to prevent the server from exhausting resources. Setting these parameters will provide you with better SharePoint applications. In this article, we will explain different parameters and how to configure them. Preparation: You must have field-level management permissions. Start: 1. Open the management center. 2. Click application management. 3. Under the Web application, Click Manage Web application. 4. Select a Web application (the functional area will light up ). 5. Click general settings-resource restrictions. 6. You will see the list view threshold value. The default value is 5000. The object model is replaced. The default value is. List View threshold of auditors and administrators-20000 by default.
List View query threshold value-default value 6. daily period of a large query-check the allowed start time and maximum duration.
Unique permission field value in the list -- 50000 by default.
Backward compatible event handler-disabled by default.
HTTP request monitoring and restriction-enabled by default.
Change log-by default, an entry is deleted from the change log 60 days later and can be set to "never".
After making the changes, click OK. Working principle: resource restrictions work at the Web application layer. Configure all website sets and Websites under the Web application. A Web application can completely disable the restriction, in HTTP request monitoring and restriction settings. By default, the resource limit is enabled, and the timer job is executed every 5 seconds. It checks the performance status of server resources. If a row of three errors is returned, the restriction status is enabled. The server remains in this status until the check is successful. When the server is in the restricted status, the user may see that the 503 server is busy. The user will need to refresh the page to see whether their request is complete. By default, the checked resources include the server CPU, memory, queuing requests, and request waiting time. The List View threshold is the number of list items that can be returned to the user. The default value is 5000. The number of List View thresholds that can be returned to the administrator or power user. The default 20000. The List View query threshold value is the maximum number of fields in the list. Default Value: 8.
The unique permission field value in the list is the project-level permission that may affect database performance verification when the list stops inheriting permissions and involves granular permissions. Therefore, you must carefully consider and plan these permissions. More: PowerShell can be used to view, set, and enable/disable resource limits. View the performance counter list
Set performance count thick ky "http://www.bkjia.com/kf/ware/vc/" target = "_ blank" class = "keylink"> vckpgltzybzcm9 "http://www.2cto.com/uploadfile/Collfiles/20140630/2014063008522729.png" alt = "\">
Disable resource limits
Enable resource limits
More information: the server CPU, memory, queuing requests, and request wait time are monitored by default. New performance counters must be added to the dual-Arab Emirates object model. You can obtain the counters used by the performance monitoring application on the server. The following is an example of how to configure the processor time: