Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Slow startup under SSMS

kipb7kipb7 Posts: 20
edited April 21, 2015 8:36AM in SQL Prompt
Just did an update from a 2-year old version, to SQL Prompt 6.4.1.142. Happy with new features, thanks!

But...

Starting SQL Server Management Studio (SQL 2008 R2) takes a minute to start up. I'm guessing it is waiting on a network or file system operation that eventually times out, but no error appears.
Looking at SQL Prompt > Help > Show Log, we see

06 Feb 2015 19:35:34,010 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() - recreating commands and cleaning up obsolete commands
06 Feb 2015 19:36:22,854 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() complete.

Perhaps this 48-second interval is responsible?

Comments

  • Also slow to change options - such as Options > Format, change something, click OK, wait 60 seconds for window to close. No error.

    Log file has (seemingly corresponding to the two times I just did this):

    07 Feb 2015 03:54:32,555 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Full
    07 Feb 2015 03:57:11,145 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Full

    It doesn't list duration, but this could be a clue of what it was doing. Perhaps it can't save the "menus" in my file system or profile.

    I found a report for a similar issue, answered Nov 22, 2011 by Anuradha D, call reference F0051414, who said "problems setting key bindings on startup...possible cause is a corrupt configuration file."
    At his request, I deleted the files and the speed improved. These same files do not seem to exist now.
  • Aaron LAaron L Posts: 596 New member
    Hi kipb7,

    Could you give this build a test and see if it helps speed things up? (this should avoid creating any commands unless absolutely necessary)

    It looks like it's slowing down while creating the commands in SSMS, which could be a result of the SSMS configuration files being corrupt or possibly they are stored in a location that's slow to write to. Is there anything special about your environment that might be causing this slow down?

    Thanks,
    Aaron.
  • Thanks, it is faster. My windows profile files are on a shared file system, which ordinarily is super zippy so I don't think that is a cause for delay, unless Red Gate opens/closes/opens/closes a lot or something.

    First time starting SSMS after update:
    12 Feb 2015 18:41:08,972 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() - recreating commands and cleaning up obsolete commands
    12 Feb 2015 18:41:51,930 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() complete.
    (about 43s)

    Second time 4s, Third time 3s.

    Thanks!
  • Aaron LAaron L Posts: 596 New member
    Thanks for confirming that fixed it! This was actually a knock on from another bug fix for some customers who kept losing their keyboard shortcuts (so we reset them on startup which is normally instant but it seems it takes a long time in some environments). We'll look into a compromise between the two.

    Thanks,
    Aaron.
  • Hello

    Just for information; I have (had...) exactly the same issue viz. very slow to load SSMS (2012), very slow to change SQL Prompt options, and (not mentioned by OP), slow to load BIDS (2008).

    I've been putting up with it for a few months, uncertain of the cause until trying to change some SQL Prompt options, when suspicion fell accordingly...

    The 6.4.1.171 build linked from above fixed all three issues.

    Cheers.
  • Hi agb,

    Glad to hear it fixed it for you! Thanks for letting us know.

    Best regards,

    David
Sign In or Register to comment.