SSMS v.18 slow? Is it me or....?

  • Hello,

    Does anyone find SSMS v.18 client to have a very slow start? ~30sec. to load and prompt for the server/database logon.

    Windows 7 and Windows 10. (64-bit).

    Thank you,

    Vinay

  • SSMS was slow for me to start up on a production server that had no access to the internet (I'm not sure if this is your situation).

    To fix this I went into Internet Explorer: Options/Advance tab. Then scroll to the bottom of the list and uncheck "Check for publisher's certificate revocation".

  • Jonathan,

    That made a "significant difference". The initial "splash" v.18 SQL server management Studio comes instantly and takes few more seconds for the server prompt. It's a little slow on the second stage, but much better than before.

    What has this to do with IE browser's setting? baffling...

    Many thanks,

    Vinay

     

  • I guess it's checking the publisher's certificate revocation on the internet but just times-out if there is no access to the website. If you stop it looking for it then you won't get any timeout.

  • Same problem with 18.4 - it takes ages to edit job steps - 17.4 version used to open the same jobs just popup immidiate.

  • I am having the same issues opening Job Steps with SSMS 18.4.  It seems to hang then suddenly opens the step.  I have tried the following suggestions.

    • Unchecked the certificate revocation within IE
    • Changed the customer feedback setting in the registry

    The issue still persists, I have installed an older version of SSMS 17.8.1 and everything is now much faster.

  • Look at the history in msdb.  If it's lengthy, clean some of it out.  You would think SQL would use master to get the dbs in SSMS, but it also uses msdb (or so it seems, at least).

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

  • It is because when SSMS loads, it Starts the Object Explorer which has our Database and Server information. Loading these information takes more time resulting delaying in start of the application.

    One thing you can do is, go to Tools > Options > Environment > Startup > Select Open Empty Environment. See if this affects your startup speed of SSMS.

    Hope this helps 🙂

  • SSMS 18.5.1 has very slow data retrieval and/or screen draws when executing multiple selects on Windows 10 Version 1809 (OS Build 17763.1282) with Lenovo updates in place and all other drivers current as suggested.

  • I also have been having so many issue with SSMS load times, 30 seconds or more to refresh Tables list, or to Edit table, right-click and wait a life time.  I spent some more time attempting things today and i found checking these enclosed in the red box made it quick again (for now). SSMS quality has been suspect for me for awhile after 17.9 (i am on latest 18.5 version). Hope this helps someone, this has been a frustration for, I am sure, not just me.

    ssms

  • imgn8sn wrote:

    I also have been having so many issue with SSMS load times, 30 seconds or more to refresh Tables list, or to Edit table, right-click and wait a life time.  I spent some more time attempting things today and i found checking these enclosed in the red box made it quick again (for now). SSMS quality has been suspect for me for awhile after 17.9 (i am on latest 18.5 version). Hope this helps someone, this has been a frustration for, I am sure, not just me.

    ssms

    Interesting... I can maybe understand how the "Trust server certificate" might make things faster but I'd normally think the "Encrypt connection" choice would slow things a down a bit.

    I've not been having any particular performance issues with 18.X but I'll give it a try and see if it makes a difference.

    Thank you for taking the time to post what you've found.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • These two steps mentioned above improved load time for SSMS from four minutes to less than one minute for me:

    1. "To fix this I went into Internet Explorer: Options/Advance tab. Then scroll to the bottom of the list and uncheck "Check for publisher's certificate revocation." (Jonathan AC Roberts)
    2. "One thing you can do is, [in SSMS] go to Tools > Options > Environment > Startup > Select Open Empty Environment. See if this affects your startup speed of SSMS." (n00b_programmer)

     

  • Hi there Nice 2 meet ya all. I am new here and hope I dont bother you with my questions.

     

    I installed SQL server 2019 (on win10 home) in combination with Autocad Plant 3D 2022.

    When using SSMS to open a very small database takes up to a minute. When I try to connect to SQL using Autocad it can take up to 30 minutes (sometime longer)

    This seems a little long to me. I hope someone can help me fixing this issue.

    Regards

     

  • I've been experience weird response in the SSMS object explorer since upgrading to 18.9.2

    I've tried all of the above fixes and still have a problem with delays.

    Simply expanding a database or right-clicking on a view /sproc to edit it can take around 15-20 seconds for the menu to appear.

    I am working on a laptop and connected to the database through a vpn, but that has been the case for the last 2+ years, and there wasnt a problem. The data retrieval is fast, when selecting from tables/views.

    If I open a new query window, the new/blank window appears withing 1 second, then 5 seconds later a "connect to database /login" screen appears (for about 4 seconds) then I get an hour glass for another 10-12 seconds before I can type.

    I upgraded SSMS to this same version on a server and there are no problems in that copy when I am RDP'd in to that server.

    Any ideas what else I can check?

  • I know this is an old thread, but I found when looking for solutions to my problem, and it might help someone else.

    I had problems since the install of SSMS v18.10 / 15.0.18390.0. The splash screen would come up after 2 or 3 seconds, but the login prompt would take 20-30 seconds to open.

    I tried (unsuccessfully) the "publisher certificate revocation" solution, the "encrypt connection / trust server certificate" solution, the "empty environment" solution; all to no avail.  I reverted all of those changes before the step that worked.

    I edited the properties of the shortcut to SSMS and checked "Run as Administrator" (in the shortcut). It causes the elevation prompt to be shown, but the splash comes up quickly with the login prompt. Time: 1.5 seconds.

    On a local network, the table refresh and job step editing went from 10 seconds to less than 1 second.

    I have no idea why this would be related to elevated permissions, but apparently it is, at least in my case.

    I hope this helps someone else.

    • This reply was modified 4 months ago by  Bradley Heisler. Reason: Added notes about table refresh and job step editing

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply