Would it be possible to display the splash screen immediately. Because it doesn't appear for aome time, I frequently start a second copy thinking the first click didn't work. If the splash screen displayed quickly, I would then wait for the program to open in its own time.

Which version of SQL Server are you talking about? In earlier versions ie SQL 2005 this is a known issue check this

http://blogs.msdn.com/b/dtjones/archive/2006/08/23/sql-server-management-studio-startup-time.aspx

http://blogs.msdn.com/b/euanga/archive/2006/07/11/662053.aspx

https://support.microsoft.com/kb/555686?wa=wsignin1.0

So you are opening SSMS, not SQL Server. You can use the start Parameter -nosplash to surpress the splash Screen, see Ssms Utility

It is not the speed of opening SSMS that I am complaining about. It is the fact that the splash screen takes an age to appear. This leads me to think that the program open has not been accepted and so open it again. I would like the splash screen to appear immediately and then I know it is being opened, however long it then takes.

So, once you opened SSMS just do not close it (SQL Server 2012) :-)

I mean if it is not a laptop ,I have never (unless needs some Windows Update) shut downed the compu

It is not the speed of opening SSMS that I am complaining about. It is the fact that the splash screen takes an age to appear. This leads me to think that the program open has not been accepted and so open it again. I would like the splash screen to appear immediately and then I know it is being opened, however long it then takes.

Hi wagham

I will start with saying that I am not familiar with the situation that you describe here, in SSMS. Usually part of the idea of splash screen is to be open as fast as we can, before any other work is dont in the application (and to use this time in order to give us some information). It should be open fast. So I am just guessing now, as I have seen those cases lot of times, in other applications, like windows applications.

1. When you have forms that seems slow to load and show, we try to reduce the number of tasks, that it needs to do on the load event. Please make sure that you re not using add-ons that actually added tasks on load, and therefore the the splash screen start slow. Try to disable all add-on for this test and open the SSMS. If it work fast, then add one by one till you find the source.

2. Are you using domain user or local user?
it might be related to domain users and connections

From the moment I click the icon to open Sql Server 2014 Management Studio, it takes 38 seconds before the splash screen appears. That is far too long. SSMS itself then opens within another 5 seconds. I want the splash screen to open within 5 seconds and SSMS to open 40secs later.

Hi,

Try to launch SQL Server Management Studio from Command Prompt.

Click Start -> Run -> Type ssms.exe or Start -> Run -> cmd -> Type SSMS.exe

This way, the splash screen appears in 15 secs and SSMS opens in another 3 secs. Why is there such a big discrepancy between starting it from an icon on the desktop? There is only one version on my C: drive so they must both be opening the same object.

Having said all that, it still takes the majority of the opening time before the splash screen appears. It should really appear almost immediately.

Hi, did you read / tested what I suggested above ?

Yes I did read your reply. I am using my own machine at home that is not connected to any network other than the internet via a broadband connection. The icon on the desktop was created by SSMS when I installed it. It just contains the path to the ssms.exe. It is not trying to load anything else. However, I did move it into a Launch Control gadget which I use to keep all my desktop icons neat and tidy. I have now moved it back onto the desktop itself. When I run it, it gives me the same timings as when using the Command Prompt.

I am not complaining about the time it takes to open SSMS. I am asking why the splash screen doesn't appear almost immediately instead of waiting for 80% of the time it takes to open SSMS.

• Edited by wagham 2 hours 10 minutes ago

Hi

>> is not connected to any network other than the internet via a broadband connection.

>> It just contains the path to the ssms.exe. It is not trying to load anything else. 

Add-ons are small patches that added to the application itself. You can not know that they are installed and that the SSMS is not try to execute them only by executing the SSMS. they work n the background.

SSMS from version 2008 or 2008r2 (not sure) is actually based on the visual studio. The application that you are using is VS. If you have VS and you installed add-ons there, then this might interfere with the SSMS.

What version are you using?!?

For 2008 versions of SSMS you can check this registry key:
Key="HKLM\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\AddIns\"
There you will find one entry per installed add-in, usually.

>> I am not complaining about the time it takes to open SSMS. I am asking why the splash screen doesn't appear almost immediately instead of waiting for 80% of the time it takes to open SSMS.

I think that we already cover this and we all understand the issue :-)
Some add-on add, might add tasks before the splash screen appear, and make it appear slow. As I mentioned in the start, this is a real option, but I do not know if this is your case, and I am just guessing op