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 EAP
SQL Source Control 2 EAP forum

How to configure the polling interval to reduce server load

Search in SQL Source Control 2 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Tue Feb 15, 2011 6:13 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.

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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