How to configure the polling interval to reduce server load

[David Atkinson]

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>

[sdoran]

What does this configuration change do? What are the effects of changing this?

[David Atkinson]

The regular polling on your server to determine what you've changed won't happen. This means that to see the blue indicators in the Object Explorer you will need to visit the Commit tab.

David