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.
Code:
<?xml version="1.0" encoding="utf-16" standalone="yes"?><!---->
<EngineOptions version="2" type="EngineOptions">
<DefaultTraceMinimumInterQueryTimeInMillis>0</DefaultTraceMinimumInterQueryTimeInMillis>
<SysObjectsMinimumInterQueryTimeInMillis>0</SysObjectsMinimumInterQueryTimeInMillis>
<SysTypesMinimumInterQueryTimeInMillis>0</SysTypesMinimumInterQueryTimeInMillis>
<DefaultTraceMinimumRequestedInterQueryTimeInMillis>0</DefaultTraceMinimumRequestedInterQueryTimeInMillis>
</EngineOptions>
THE v1 DEFAULT VALUES ARE:
25000 DefaultTraceMinimumInterQueryTimeInMillis
2500 SysObjectsMinimumInterQueryTimeInMillis
3500 SysTypesMinimumInterQueryTimeInMillis
5000 DefaultTraceMinimumRequestedInterQueryTimeInMillis
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.
Code:
<?xml version="1.0" encoding="utf-16" standalone="yes"?><!---->
<EngineOptions version="2" type="EngineOptions">
<DefaultTraceMinimumInterQueryTimeInMillis>0</DefaultTraceMinimumInterQueryTimeInMillis>
<SysObjectsMinimumInterQueryTimeInMillis>0</SysObjectsMinimumInterQueryTimeInMillis>
<SysTypesMinimumInterQueryTimeInMillis>0</SysTypesMinimumInterQueryTimeInMillis>
<DefaultTraceMinimumRequestedInterQueryTimeInMillis>0</DefaultTraceMinimumRequestedInterQueryTimeInMillis>
</EngineOptions>
THE v1 DEFAULT VALUES ARE:
25000 DefaultTraceMinimumInterQueryTimeInMillis
2500 SysObjectsMinimumInterQueryTimeInMillis
3500 SysTypesMinimumInterQueryTimeInMillis
5000 DefaultTraceMinimumRequestedInterQueryTimeInMillis