Disable Throttling on a List-by-List Basis

A Farm Administrator can disable Throttling on a list-by-list basis. To do this, run the following:

$web = Get-SPWeb http://webapp1
$list = $web.Lists["MyList"]
$list.EnableThrottling = $false
$list.Update()

To validate the Throttling settings are effective, run:

$list.IsThrottled

If it returns True, the the List has been throttled (has more items than the List View Throttle limit). If it returns false, it has either less than the List View Throttle limit or throttling has been disabled via the EnableThrottling property.

To re-enable throttling on a list, simply run

$list.EnableThrottling = $true
$list.Update()

Todd Klindt has a PowerShell script to create a list with 5,001 items.

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.