Red Gate forums :: View topic - How to configure the polling interval to reduce server load
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

How to configure the polling interval to reduce server load

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Tue Feb 15, 2011 6:11 pm    Post subject: How to configure the polling interval to reduce server load Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
sdoran



Joined: 25 Jan 2007
Posts: 9

PostPosted: Thu Jul 19, 2012 8:07 pm    Post subject: How to configure the polling interval to reduce server load Reply with quote

What does this configuration change do? What are the effects of changing this?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Thu Jul 19, 2012 8:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group