How can we help you today? How can we help you today?

How to configure the polling interval to reduce server load

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
0

Comments

3 comments

Sort by
  • sdoran
    What does this configuration change do? What are the effects of changing this?
    sdoran
    0
  • 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
    David Atkinson
    0
  • NaM_Cat
    Hi! How can I set this option as default for users or for new users?
    NaM_Cat
    0

Add comment

Please sign in to leave a comment.