Update: This problem exists even with SSMS v18.2 (2. How can I diagnose what's wrong with SSMS. It's a shame that a program from such a reputable company can't work smooth out of the box, and troubleshooting it is sooooooooooooooo difficult.Ĭould you please help.
Here are the things I've done so far, without effect: SQL Server Management Studio application is free to download and offers easy-to-install, easy-to-use, secure, and reliable Developer Tools applications. It's clearly apparent that SSMS is doing something for each activity, and it gets stuck somewhere.
0 (X64) 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 18362: )Īny activity I want to do in it, from opening, to connecting to a database engine, to right-clicking on a database, to creating a new database, to opening up a new query window, to browsing tables, any activity that is not query takes like 5 to 10 seconds to perform. As with previous versions of SSMS, you still get it bundled with your SQL Server install, but with this new release we now also have the option of downloading SSMS separately via its own lightweight installer. Windows 10, build 1903 (freshly installed) Microsoft has released a new standalone version of SQL Server Management Studio (SSMS).
In our Software Asset Management practice we detect SQL Server Management Studio at a regular basis. It is based on the Visual Studio user interface and has been around since SQL Server 2005. I know this question has been asked before here and here. SQL Server Management Studio is a very useful set of tools for managing SQL Server Databases.