Very frequent disk activity
When I have SSMS open with a DB linked to TFS I hear a burst of disk activity every 4 seconds. It's driving me to distraction. What can I do, other than unlike the DB whenever I'm not actually doing an update?
Anonymous
shared this idea
-
AdminJames Billings
(Admin, Redgate)
commented
Most likely you're seeing activity from SQL Source Control polling for changes to the database. You can reduce the frequency of this by editing a configuration file:
Edit the RedGate_SQLSourceControl_Engine_EngineOptions.xml file in C:\Users\<username>\Appdata\Local\Red Gate\SQL Source Control 3.
Set the trace interval time as follows:
<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>
(you may need to add that line if it's not already there).
Once done, ensure you restart SSMS; also, you will need to perform this change on each PC / for each user.