Servers throtttle and CPU increase

sns 9,226 Reputation points
2023-04-17T16:45:41.1333333+00:00

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?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,247 questions
0 comments No comments
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 20,741 Reputation points Microsoft Vendor
    2023-04-18T02:46:35.3933333+00:00

    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.


0 additional answers

Sort by: Most helpful