ON - Premise SharePoint throttling

As with Microsoft Exchange servers, throttling is also used on SharePoint.

SharePoint throttling

.Sometimes it is needed to turn it off in order for Data&More Toolbox to get data without any bottlenecks in the way. 

SharePoint 2013 and 2016

To disable throttling, open up Powershell and enter next code block:

$web = Get-SPWeb http://<sharepoint>
$list = $web.Lists["site_lists"]
$list.EnableThrottling = $false
$list.Update()

 

To validate that throttling settings are effective, type:

$list.IsThrottled