How to configure the polling interval to reduce server load

David AtkinsonDavid Atkinson Posts: 1,406 Rose Gold 2
If your server is struggling due to the default blue indicator polling frequency, it is possible to reconfigure it.

All SQL Source Control users need to set this individually.

To achieve this you will need to close SSMS, and edit the 'RedGate_SQLSourceControl_Engine_EngineOptions' in your SQL Source Control configuration directory. This is either: C:\Users\<username>\AppData\Local\Red Gate\SQL Source Control 3 or C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Source Control 3 depending on your operating system version.

Add the following node (as a child of the EngineOptions node) to the file:

<PollingEnabled>False</PollingEnabled>
David Atkinson
Product Manager
Redgate Software

Comments

Sign In or Register to comment.