How to configure the polling interval to reduce server load

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

How to configure the polling interval to reduce server load

Postby David Atkinson » Tue Feb 15, 2011 6:13 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Return to SQL Source Control 2 EAP

Who is online

Users browsing this forum: No registered users and 0 guests