Joined: 05 Dec 2005
|Posted: Tue Feb 15, 2011 6:13 pm Post subject: 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.
The settings are in milliseconds. If you set the interval to '0', it will turn off polling entirely, which means the blue indicators in the Object Explorer will only be set when the Commit tab is visited, but it should reduce the load on your database server.
All SQL Source Control users need to set this individually.
To achieve this you will need to 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 1 or C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Source Control 1 depending on your operating system version.
The following XML is an example of setting the polling frequency to '0'. This will mean that SQL Source control will not check for changes until you visit the Commit tab. You might want to try different values between 0 and the defaults, until you have an acceptable performance.
<?xml version="1.0" encoding="utf-16" standalone="yes"?><!---->
<EngineOptions version="2" type="EngineOptions">
THE v1 DEFAULT VALUES ARE: