Slow startup under SSMS

• 
  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.

  kipb7 February 06, 2015 23:06

  - 0 +
• 
  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.

  Aaron L February 09, 2015 02:58

  - 0 +
• 
  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!

  kipb7 February 12, 2015 13:57

  - 0 +
• 
  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.

  Aaron L February 16, 2015 04:27

  - 0 +
• 
  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.

  agb April 21, 2015 07:01

  - 0 +
• 
  Hi agb,
  
  Glad to hear it fixed it for you! Thanks for letting us know.
  
  Best regards,
  
  David

  David Priddle April 21, 2015 08:36

  - 0 +

Add comment

Please sign in to leave a comment.