Sharepoint: view cannot be displayed because the number of search and workflow columns found exceeds a threshold value (8)

Question

I have the following problem with my Sharepoint site. (It is not possible to display the view because the number of search and workflow columns found in it exceeds the threshold value (8) entered by the administrator), but any solution I found on the Internet tells me to change the throttle settings in the web application settings in central administration. My problem is that I just don't have centralized administration> web applications, etc. The problem arises in the document library for me, and I studied very much the settings on the site, but I can not find anything about trotting or the threshold of the column. I have site settings> Library settings, etc.

How to increase the threshold of a column in this case?

I am working on a Sharepoint website and have Workspace and Designer 2010.

Answer 1

The information you found is correct. You must access the Central Administration site from the server itself. It seems that you do not go to the server, but use the SPD and Sharepoint site from your workstation. If you do not have access to the RDP server, you should contact someone who has access.

Another note does not recommend increasing this threshold.

Answer 2

Use caution when changing this parameter:

This has a very significant effect on SQL performance. In the article below, you can see that in tests for people using 8 and performing a query, SQL had about 7% of the processor load. Moving to 10 and executing a query that returns 10 columns increases CPU utilization by up to almost 40%. http://sympmarc.com/2012/07/23/sharepoints-list-view-lookup-threshold-and-why-we-dont-change-it/

You can also read the white paper here: http://technet.microsoft.com/en-us/library/ff608068(office.14).aspx

Answer 3

Application Management> Web Application Management. In the list of web applications, select the desired web application. Then go to General Settings> Resource Throttling. In the Resource Throttling window, scroll down to List Search Threshold and change the value to a number that matches your needs.