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?
AdminJames Billings (Admin, Red Gate) 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:
(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.