Servers throtttle and CPU increase

Question

Noticed CPU spike in Sharepoint server because if which sites were not accessible however some one disabled throttling and it fixed issue what is tat throttle?

Answer 1

Hi @sns ,

The throttling feature helps to avoid performance hits in SharePoint. We can disable Throttling on SharePoint List using PowerShell

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Use the below script to disable list throttling in SharePoint server 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:

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

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.