Adjusting polling interval to the StagingLog.mdb

By default, in Commerce Server 2007 and Commerce Server 2009 the Commerce Staging System (CSS) will poll the StagingLog.mdb every 5 seconds.  Under normal circumstances this polling interval is not an issue but under an highly used CSS system the frequent polling may cause the service to crash. If you are running into the issue, you can increase the polling interval which may resolve the issue.

To increase the polling interval you will need to edit the registry. First stop the service, make the registry modification and then restart the service.

The registry key is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CSS\ProjectDeploymentLog\PollingInterval

Default = 5000 (stored in milliseconds)

A good recommendation on a value to use is somewhere between 30 seconds (30,000) and 60 seconds (60,000). Along with increasing the polling interval you can configure the CSS service to restart automatically by setting the recovery options to Restart the Service on failure.

The issue causing the service to crash is being investigated further and as updates become available I will update this post.