What are the challenges you face when working across database platforms? Take the survey

SQL Server Management Studio slow startup times

JP7JP7 Posts: 17
edited August 18, 2011 10:59AM in SQL Prompt Previous Versions

Since installing SQL Prompt I've been experiencing extremely slow startup times of SSMS 2008 R2 and VS2010.

I noticed that two entries get recorded in the logs:

07 Mar 2011 06:48:55,313 [10] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at RedGate.SQLPrompt.CommonUI.TaskExecuter.Executer.


  • Options
    Hi JP7,

    Slow startup times can be caused by the Check for Updates mechanism not managing to reach our server. Please try going to the SQL Prompt 5 menu and choosing Check for Updates... Then uncheck the box in the bottom-left corner called Check for updates on startup.

    Please post here whether this has helped or not.

    We are tweaking the Check for Updates mechanism in SQL Prompt 5.1 so that even if your machine can't reach our server easily, it still doesn't slow down the startup of SSMS.

    Paul Stephenson
    Project Manager, Red Gate
  • Options
    Hi Paul

    Your suggestion dramatically improved the load times. Looking forward to V5.1.


  • Options
    I did the SSMS > SQL Prompt 5 > Help > Check for Updates ...
    and it says I have the latest version, and I unchecked
    "Check for updates on startup"
    but it still takes 30 seconds to start up SSMS.
    One must use a proxy on our network to get outside, so that may interfere with phoning home.
Sign In or Register to comment.