Disable Throttling on SharePoint List using PowerShell

The throttling feature helps to avoid performance hits in SharePoint. We set throttling limits for an entire web application, and it’s not possible to set throttling limits on a specific SharePoint list or library. But we can disable/enable throttling on SharePoint lists.

PowerShell to disable list throttling:

Use the below script to disable list throttling in SharePoint 2010 using PowerShell.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Variables for Site URL and List Name
$WebURL = "https://sales.crescent.com"
$ListName = "Proposal Documents"
 
#Get the Site and List objects
$web = Get-SPWeb $WebURL
$List = $Web.Lists[$ListName]

#Disable throttling on the list
$list.EnableThrottling = $false
$List.Update() 

Find All Lists with List Throttling disabled

To find all lists with list throttling disabled in your SharePoint environment, use this PowerShell script. It scans all web applications in the current environment for lists with throttling disabled and exports the results to a CSV file.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
 
#Get All Web Applications
$WebAppsCollection = Get-SPWebApplication
 
#Array to Hold Result
$ThrottlingLists = @()

#Loop through each web application 
foreach($WebApp in $WebAppsCollection)
{
    #Loop through each site collection 
    foreach($Site in $WebApp.Sites)
    {
	    #Loop through each web
        foreach($Web in $Site.AllWebs)
        {
            Write-host "Scanning site:"$Web.URL             
            foreach($List in $Web.Lists)
            {
                if($list.EnableThrottling -eq $False)
                {
                    $Result = New-Object PSObject
                    $Result | Add-Member NoteProperty Title($list.Title)
                    $Result | Add-Member NoteProperty URL($web.URL)                     
                    #Add the object with property to an Array
                    $ThrottlingLists += $Result
                }
            }
        }
    }
}
Write-host "Total Number of Lists with Throttling disabled:"$ThrottlingLists.Count -f Green
 
#Export the result Array to CSV file
$ThrottlingLists | Export-CSV "c:\temp\ThrottlingListData.csv" -NoTypeInformation

Related post: Configure Resource Throttling in SharePoint 2013 using PowerShell

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

2 thoughts on “Disable Throttling on SharePoint List using PowerShell

  • how to you get a report of which lists have been throttled in a site collection or a web/app?

    Reply
    • Article updated with a script to scan and get the inventory of lists with throttling disabled!

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *