SQL Server Management Studio (SSMS) is slow

Leave a comment (0) Go to comments

My SQL Server Management Studio (SSMS) takes approx. 2-3 minutes to open, is there any way to speed that up?

YES, we can speed up the opening time for SQL Server Management studio by taking some preventive actions.

When ever we open a SQL Server Management Studio, if performs the following actions

  1. Initiate a windows process by creating a new Process ID at Windows level, which is subject to be scanned by Antivirus software, in you have any.
  2. Splash Screen displaying “Microsoft SQL Server”
  3. Ask for Connection Information like
    • Server Type
    • SQL Server Name
    • Login Credentials like Authentication Mechanism, LOGIN ID and Password, in case this is SQL Server
  4. Resolve the Server name and sent Authentication Request to Server.
  5. SQL Server Management Studio also perform a ”checks for Server certificate revocation and publisher’s certificate revocation
  6. Build SSMS environment by user specified / default settings
  7. and then you finally use SQL Server Management Studio

Ohhh you never thought, it’s going to do so much by when you just open a SSMS. So now we need to simple and shorten these tasks to speed up the SSMS performance.

Steps to Boost up SSMS opening Time

  1. Configure your antivirus to Exclude the scan of SSMS.exe if your enterprise policy doesn’t allow that than put SSMS at least in Low Risk processes. I am showing a screen shot of McAfee as I use that as antivirus SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server
  2. Instead of opening SQL Server Management studio by clicking Start >> All Programs >> Microsoft SQL Server >> SQL Server Management Studio. Instead of this either open from a RUN MENU by typing “SSMS.exe /nosplash”, this will skip the Splash Screen displaying “Microsoft SQL Server”
  3. if we are going to connect mostly one identified SQL Server Instance and database, we can supple these settings too while opening SSMS SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server  OR we can also create a shortcut for SQL Server Management Studio and supply all these a parameters.  SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server  where  –S is SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server   
  4. After this network settings are being used to identify, how to reach out to SQL Server. it might use DNS Server for resolution, in case you are connecting over a slow connection and over WAN it might add delay of few mili seconds, it would be definitely a added advantage, if you could add the Client Alias in SQL Server Configuration Manager SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server
  5. If you are not encrypting the data using any Certificate,the it would be good idea to uncheck these options ”checks for Server certificate revocation and publisher’s certificate revocation” SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server
  6. Even SSMS takes 1-2 seconds to build environment as per your settings. I prefer to open a empty environment, SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server
  7. I would also suggest you to use the local help only, incase you have that installed. SQL Server Management Studio (SSMS) is slow sql server management studio is slow SQL Server Management Studio has stopped working SQL Server Management Studio hanging SQL Server Management Studio Hang SQL Server Management Studio (SSMS) start faster increase SQL Server Management Studio SSMS performance Hangs forever while connecting local/remote server

TAGS: Hangs forever while connecting local/remote server,sql server management studio is slow, SQL Server Management Studio hanging ,SQL Server Management Studio (SSMS) start faster,SQL Server Management Studio has stopped working,SQL Server Management Studio Hang, increase SQL Server Management Studio SSMS performance


EOF - SQL Server Management Studio (SSMS) is slow, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.