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:11 pm

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>
Last edited by David Atkinson on Tue May 22, 2012 3:46 pm, edited 7 times in total.
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

How to configure the polling interval to reduce server load

Postby sdoran » Thu Jul 19, 2012 8:07 pm

What does this configuration change do? What are the effects of changing this?
sdoran
 
Posts: 9
Joined: Thu Jan 25, 2007 3:01 pm

Postby David Atkinson » Thu Jul 19, 2012 8:14 pm

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


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 1 guest