- September 23, 2021
- Posted by: Surender Kumar
- Category: SQL Server
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.
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.