Home > PowerShell, SharePoint > Increase the Default Throttle Size from 2000 for BCS in SharePoint 2010

Increase the Default Throttle Size from 2000 for BCS in SharePoint 2010


 

1) Open Microsoft SharePoint PowerShell

a) Go to Start>All Programs > SharePoint 2010 Products >

b) Right Click on SharePoint 2010 Management Shell to open the Powershell as an Administrator.

2) Type the following command:

Command # 1 :

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName –eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

Command #2 :

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 100000000 -Default 500000

Command #3 :


Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy

Verify that the output looks like this:

 

Scope : Database

ThrottleType : Items

Enforced : True

Default : 500000

Max : 100000000

Advertisements
Categories: PowerShell, SharePoint Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: