Tuesday 11 March 2014

SQL Server Management Studio (SSMS) is slow

 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
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
  1. 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”
  2. if we are going to connect mostly one identified SQL Server Instance and database, we can supple these settings too while opening SSMS

No comments:

Post a Comment