Tuesday, December 1, 2020

Get lists and libraries where throttling is disabled using powerShell

  •  how to disable throttling on single lists but if we don’t monitor this and keep disabling it can turn in to a nightmare for admins. 
  • When you disable throttling on a list basically you give it a pass to go and complete the operation no matter how long it takes.
  •  This is not a good idea especially when the number of items in the list/library is large.
  • This will block other operations /queries from execution and can cause a huge increase in the page load or overall performance of Sharepoint farm.
  • Also, there is a reason why MS has implemented this feature at the web application level at Manage web applications > Select web application > General Settings > Resource Throttling.
  • So back to the issue, I wanted to find out if there are more than one lists/libraries with throttling disabled.


$WA=Get-SPWebApplication http://str-emp.peakfinder/
$SCs=Get-SPSite -WebApplication $WA
Foreach($SC in $SCs.url)
{
$Webs=Get-SPWeb -Site $SC
foreach($web in $Webs)
    {
        $Lists=$web.Lists
    foreach ($list in $Lists)
        {
        if($list.EnableThrottling -eq $false)
           {
           Write-Host "Site Name = " $web.Title
           Write-Host "Site URL = " $web.Url
           Write-Host " Throttling is Disabled on " $list.Title 
           }
        }
    }
}

No comments:

Post a Comment