Red Gate forums :: View topic - SQL Management Studio 2005 hangs upon start
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

SQL Management Studio 2005 hangs upon start

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
anders____j



Joined: 22 Jun 2010
Posts: 3

PostPosted: Tue Jun 22, 2010 9:17 am    Post subject: SQL Management Studio 2005 hangs upon start Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Sat Jun 26, 2010 9:30 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
General1



Joined: 06 Apr 2006
Posts: 12

PostPosted: Tue Jul 20, 2010 8:07 am    Post subject: Reply with quote

Hi,

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

Dirk
_________________
Dirk
Back to top
View user's profile Send private message
meklembl



Joined: 24 Aug 2007
Posts: 89
Location: Solon, OH, USA

PostPosted: Fri Jul 30, 2010 6:01 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
HowardW



Joined: 08 Sep 2010
Posts: 1

PostPosted: Wed Sep 08, 2010 9:45 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
krist17860



Joined: 30 Sep 2010
Posts: 1

PostPosted: Thu Sep 30, 2010 6:51 pm    Post subject: SSMS hangs when starting, shows splash screen. Reply with quote

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.
Back to top
View user's profile Send private message
anders____j



Joined: 22 Jun 2010
Posts: 3

PostPosted: Tue Oct 12, 2010 7:39 am    Post subject: SQL refactor Reply with quote

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...
Back to top
View user's profile Send private message
faudisio



Joined: 28 Oct 2010
Posts: 1

PostPosted: Thu Oct 28, 2010 10:17 am    Post subject: Update please Reply with quote

Hi Brian.

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

Thanks,
Fabrizio
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Fri Oct 29, 2010 3:37 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
johnlwebb



Joined: 21 Aug 2012
Posts: 1

PostPosted: Tue Aug 21, 2012 5:29 pm    Post subject: I'm having a similar problem. Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group