TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Post an article
Translate this page
Powered by
Microsoft® Translator
Wikis - Page Details
First published by
Waqas Sarwar(MVP)
When:
22 Apr 2016 6:56 PM
Last revision by
Richard Mueller
(MVP, Microsoft Community Contributor)
When:
23 Apr 2017 5:57 PM
Revisions:
10
Comments:
6
Options
Subscribe to Article (RSS)
Share this
Engage!
Wiki Ninjas Blog
(
Announcements
)
Wiki Ninjas on Twitter
TechNet Wiki Discussion Forum
Can You Improve This Article?
Positively!
Click Sign In to add the tip, solution, correction or comment that will help other users.
Report inappropriate content using
these instructions
.
Wiki
>
TechNet Articles
>
SharePoint 2016: List View Threshold
SharePoint 2016: List View Threshold
Article
History
SharePoint 2016: List View Threshold
As we were all expecting that in SharePoint 2016 the List View Threshold will be changed, it is.
List View Threshold changed from a maximum 5000 items per view to
greater than 5000 items
. Yes, you are reading it correctly, Now it is more than 5000 items in a view but what is an upper limit? Sorry, we don't know.
Upper Limit:
It depends on the SQL hardware, SharePoint server's hardware, and structure of site collections.
Now they introduced new values for the following.
List View Threshold: Greater than 5000.
Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time outside the daily time window set by the administrator during which queries are unrestricted.
When
adding or removing a column index,
the
threshold is 20,000
by default.
When
deleting a list or folder
, the
threshold is 100,000
by default.
When
renaming a folder
within the same library, the
threshold is 100,000
by default.
List view threshold for
auditors and administrators
will remain same at 20,000.
List view lookup threshold:
12 join operations per query
But keep in mind, we still can change these values at web application level.
With SharePoint 2016, MSFT introduced Auto Indexing the large list view in SharePoint. This means if List View Threshold is set at 5000 and item reaches 2500 in a list view then SharePoint automatically indexes the column.
Reference:
SharePoint 2016 software boundaries and limit