Set BCS Throttle Limits SharePoint 2010

You can set various types of BCS Throttle limits using this powershell snippet :-)


$bdcAppProxy = Get-SPServiceApplicationProxy | Where {$_ -match "Business Data Connectivity"}

$throttleDb = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcAppProxy

Set-SPBusinessDataCatalogThrottleConfig -Identity $throttleDb -maximum 120000 -default 100000

$throttleWCF = Get-SPBusinessDataCatalogThrottleConfig -Scope WCF -ThrottleType Size -ServiceApplicationProxy $bdcAppProxy

Set-SPBusinessDataCatalogThrottleConfig -Identity $throttleWCF -maximum 1000000 -default 5000000 

$throttleConn = Get-SPBusinessDataCatalogThrottleConfig -Scope Global -ThrottleType Connections -ServiceApplicationProxy $bdcAppProxy Set-SPBusinessDataCatalogThrottleConfig -Identity

$throttleConn -maximum 200 -default 150