This view cannot be displayed because it exceeds the list view threshold (15000 items) enforced by the Administrator

Issue: This view cannot be displayed because it exceeds the list view threshold (15000 items) enforced by the Administrator

Possible solutions:

1.       Index based Filtering :

·         Create one or more Indexed columns on the List/Library

Go to Document Library/List settings à Indexed columnsàCreate new index àselect primary column à create

·         Modify the view and use the indexed column to filter the items

2.       Metadata navigation filtering:

·         The Metadata Navigation and Filtering feature is enabled by default on most sites. If it is not enabled for the site, we can enable it on the Site Features pages for the site.

·         The user must be a Site Owner or a Site Collection Administrator to enable Metadata Navigation and Filtering.

• Site Settingsà Site Actions àclick Manage site featuresà Activate Metadata navigation and filtering.

Configure Metadata Navigation

·         The user must have a least the Manage Lists permission level to configure metadata navigation for a list or library.

·         Go to the list or library settingsà General Settingsà Metadata navigation settings.

·         In the Configure Navigation Hierarchies section, select the field or fields you want to display in the navigation hierarchy and then click Add.

·         By default, Folders are automatically displayed in the navigation hierarchy. If you do not want folders to display, select Folders, and then click Remove.

·         In the Configure Key Filters section, select the fields you want to add as Key Filters, and then click Add.

·         In the Configure automatic column indexing for this list, It is recommended that we select the option Automatically manage column indices on this list. Click OK

33. Increase Threshold limit:

• Open the SharePoint Central Administration,
• go to Application Management --> Manage Web Applications
• Click to select the web application that hosts your list (eg. SharePoint - 8080)
• At the Ribbon, select the General Settings and select Resource Throttling
• Then, you can see the 5000 List View Threshold limit and you can edit the value you want.
• Click OK to save it.

But the problem is, If Threshold limit increases the requests per second b/w SQl DB and SharePoint decreases. Due to this performance will gets effected.