SQL Management Studio 2005 hangs upon start

Provides intelligent code completion for SQL Server editors.

SQL Management Studio 2005 hangs upon start

Postby anders____j » Tue Jun 22, 2010 8:17 am

We are new some new users at our company of RedGate SQL Toolbelt with different content (I have "SQL Comparison Bundle") but we all experience the problem: SQL Server (2005) Management Studio (SQLWB.exe) hangs/stalls for at least 10 minutes upon start (when showing the splash screen). Also Visual Studio 2005 hava a similar problem but the "hang" is not for as long time. This started for everyone when installing RedGate products.

We are running WXP.

Any ideas how to solve this?

Update: I forgot to mention, a collegue of mine noticed that the was some file (which is located on a network drive) redgate/management studio accessed many thousand times during startup. It is files located at J:\\Application Data\\Microsoft\\Microsoft SQL Server\\90\\Tools\\Shell (in our case a nnetwork drive, which is the problem). According to MS Management Studio should not write to these files - only addinns etc.
Posts: 3
Joined: Tue Jun 22, 2010 8:05 am

Postby Brian Donahue » Sat Jun 26, 2010 8:30 am

Hi Anders,

I believe we have created a support indident for you and are looking into this. I think the problem is caused by the keyboard shortcut setup, which hits the user.vsk and current.vsk files repeatedly. If bits of your user profile are redirected to a network share, this becomes a very slow operation, but we don't know yet if we have done something in a less-than-optimal way or if it's just the way that VS and SSMS do the operations that causes the problem. As far as I can tell, SQL Prompt only sets the shortcut keys once on initialization (in the addin's Connect method).
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby General1 » Tue Jul 20, 2010 7:07 am


I have had this same problem in Sql Server 2008 Management Studio after installation of Sql Prompt 4.0 only.
Visual Studio does not experience a slow down.
I just downloaded and installed it on my new work-PC. (Windows XP, Sql server 2008)
When SSMS starts up, it shows its logo, then waits a few seconds, then the logo disappears. The process is still running, but doesn't show itself.
Then I kill the process immediately and start it again. Then ssms starts up immediately (most of the time).

Posts: 12
Joined: Thu Apr 06, 2006 3:30 pm

Postby meklembl » Fri Jul 30, 2010 5:01 pm

I've had the same issue with both SSMS 2005 and SSMS 2008. I never gave it a thought that the issue may be with SQL Prompt. I had thought it was more with Vista and User Account Control settings.
Larry M
Cleveland, OH USA
Posts: 105
Joined: Fri Aug 24, 2007 2:08 pm
Location: Solon, OH, USA

Postby HowardW » Wed Sep 08, 2010 8:45 am

Same problem here. All developers have the same issue - I've just done a fresh rebuild on Windows 7, tested management studio several times, installed SQL Toolbelt and immediately have the same issue again.

Splash screen comes up then hangs until you kill ssms and try again (at which point it mostly comes to life straight away).

We're behind an ISA proxy server, other than that there's nothing particularly unusual about our environment (and it happens on a mix of OS's)

Any news on a fix for this?
Posts: 1
Joined: Wed Sep 08, 2010 8:39 am

SSMS hangs when starting, shows splash screen.

Postby krist17860 » Thu Sep 30, 2010 5:51 pm

Runing on Windows7, SQL 2008r2,

when I open it takes 5 minutes to start. This behaviour began after SQL toolbelt install.

Solution ? , uninstall SQL toolbelt ?

Analysis shows that file : c:\\ProgramData\\Red Gate\\SQL Search\\Archive\\RedGate.SQLsearch.Addin.dll
is being bombarded during startup.
Posts: 1
Joined: Thu Sep 30, 2010 5:21 pm

SQL refactor

Postby anders____j » Tue Oct 12, 2010 6:39 am

I am pretty sure it is SQL Refactor causing this. When unistalled the problem goes away, and when reinstalling problem is back.

I'm really looking forward to a hotfix for this...
Posts: 3
Joined: Tue Jun 22, 2010 8:05 am

Update please

Postby faudisio » Thu Oct 28, 2010 9:17 am

Hi Brian.

Please, can you update us about the status of the support incident?
Is a solution under development?

Posts: 1
Joined: Thu Oct 28, 2010 9:07 am

Postby Brian Donahue » Fri Oct 29, 2010 2:37 pm

Hi Fabrizio,

Thanks for bringing this up, as it's a good time to discuss the future direction for SQL Refactor development. Basically some of the functionality of Prompt and Refactor has overlapped for the last couple of years, like format SQL. The decision we came to was that it made more sense to have one SSMS add-in rather than two, so Refactor is being swallowed up into SQL Prompt 5. If you already own Prompt with support, you can upgrade to SQL Prompt 5 and uninstall the SQL Refactor add-in.

We are also going to allow SQL Refactor users with a support entitlement at the time of release of SQL Prompt 5 to upgrade from Refactor to Prompt 5. This way, nobody with a support contract will lose any functionality. If you have any questions about an upgrade path, you can ask the Red Gate sales team.

If you want to trial a beta of SQL Prompt 5, one is available on the SQL Prompt EAP 5 Forum.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

I'm having a similar problem.

Postby johnlwebb » Tue Aug 21, 2012 4:29 pm

I installed Red Gate SQL Developer Bundle and now both SQL Management Studio 2008 and Visual Studio 2008 get stuck on their splash screen when starting. has anyone found a solution to this?
Posts: 1
Joined: Tue Aug 21, 2012 4:27 pm

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests