One of the improvements in SharePoint 2010 is more granularity on managing resource throttling for your web applications.
If you navigate to Central Administration -> Manage Web Applications -> select web application, you will have an option on a ribbon to manage web application settings and throttling is one of the options.
When you perform an automated deployment – you probably want to set most of the settings here using a script or code.
Here are few options I found useful to be able to set using PowerShell.
Open SharePoint 2010 Command Shell and connect to your site collection:
$site = spsite "http://[your site collection URL]"
Here are some other options you might want to set using PowerShell or object model:
List View Threshold
Specify the maximum number of items that a database operation can involve at one time. Operations that exceed this limit are prohibited.
$site.WebApplication.MaxItemsPerThrottledOperation
Specify the maximum number of items that an object model database query can involve at one time for users to whom you grant sufficient permissions through Security Policy.
$site.WebApplication.MaxItemsPerThrottledOperationOverride
If you choose to allow object model override, users to whom you grant sufficient permission can override the List View Threshold programmatically for particular queries.
$site.WebApplication.AllowOMCodeOverrideThrottleSettings
Specify the maximum number of Lookup, Person/Group, or workflow status fields that a database query can involve at one time.
$site.WebApplication.MaxQueryLookupFields
More to follow … enjoy!
