Disabling list view throttling temporarily or even permanently
A troublesome issue when working with very large (5000 items or more) SharePoint 2010 lists is list view throttling. It was introduced in SP2010 to limit the amount of requests that can be made as that inhibited server performance and for day to day running this is fine. But when you're trying to migrate content from a huge MOSS 2007 list to an SP2010 list with view throttling it is a big issue.
There are a couple of things you can do to work around this issue.
Temporarily disable using SharePoint Central Admin:
Manage web applications → Select Web Application → General Settings → Resource Throttling
You then get to this page
You then have some useful options here including thresholds and Http throttling.
The options that you need to change to temporarily disable List View throttling are:
- Set the "Daily time window for large queries" to enabled for the duration you require. This will temporarily remove the throttling,
- You can also disable "HTTP request monitoring and throttling", this will de-restrict the web front end request limits, from a SharePoint perspective at least.
Permanently disable throttling using PowerShell
In the SharePoint Management Shell run the following command against your webapp:
$web = Get-SPWeb $list = $web.Lists[“”] $list.Enablethrottling = $false $list.Update() $web.Dispose()
This will permanently disable throttling and cannot be changed using the UI.