How to fix slow startup for SQL Server Management Studio

Publish Date: September 23, 2021

Fix slow startup for SSMS

Do you use the latest version of SQL Server Management Studio? If you do, you might also face an issue where the SSMS takes way too much time to start. If you are facing slow startup issue in SSMS v18.x, the following video will help you significantly speed up its startup process.

Microsoft Certified | Cisco Certified

1 Comment

  • Daniel

    Ssms / SQL Server Micrsoft Studio slow load time *FIX*

    Disable Fusion Logging:
    Press Win + R to open the Run dialog.
    Type regedit and press Enter to open the Windows Registry Editor.
    Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion
    On the right pane, set the LogFailures DWORD value to 0 to disable logging.
    Optionally, also set ForceLog DWORD value to 0 to further ensure logging is disabled.
    Close the Registry Editor.
    Clean Up Existing Logs (if desired):
    Navigate to C:\FusionLog\ in File Explorer.
    You can safely delete logs in this directory to reclaim disk space if needed.
    Restart SSMS and observe the behavior in Process Monitor again. The flood of Fusion Log writes should no longer be present.
    In case Visual Studio was loading slow. This will fix that too.

Leave a Reply