SQL Source Control slows down Object Explorer in SSMS

If Object Explorer is slow to respond after installing SQL Source Control, it may help to disable the automatic polling option.

You can disable this from Options>Indicate changed objects in the Object Explorer and update indicators every X seconds. Please untick the option, restart SSMS, and test.

If the slowness persists, however, it may be due to the object locking feature. To disable this:

  1. Close SSMS
  2. Open the file %localappdata%\Red Gate\SQL Source Control X\RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor

  3. Add the tag to disable object locking as below:
    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <!---->
    <EngineOptions version="3" type="EngineOptions">
    <EnableObjectLocking>False</EnableObjectLocking>
    </EngineOptions>
  4. Restart SSMS to test

If the problem persists after following these troubleshooting steps, please log a ticket with support.

Was this article helpful?

7 out of 24 found this helpful
Have more questions? Submit a request