How to configure the polling interval to reduce server load
David Atkinson
Redgate › Posts: 1,457 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>
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
Product Manager
Redgate Software
Comments
David
Product Manager
Redgate Software