SSMS 2014 running slow

• alex.palmer

  SSCrazy

  Points: 2292

  More actions

  March 8, 2017 at 2:53 am

  #321068

  Hi

  I recently uninstalled SSMS 2008R2 and installed 2014

  Microsoft SQL Server Management Studio - 12.0.4100.1
  Microsoft Analysis Services Client Tools -  12.0.4100.1
  Microsoft Data Access Components (MDAC) -  10.0.14393.0
  Microsoft MSXML - 3.0 6.0
  Microsoft Internet Explorer  - 9.11.14393.0
  Microsoft .NET Framework  - 4.0.30319.42000
  

  Operating System - 6.3.14393

  
  Now whenever I open SSMS on browse the databases with Object explorer details pane open SSMS starts using 30-40% of the cpu.

  A ProcMon trace show SSMS continuously going through this loop
  
  It appears to be looking for this path
  C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Sd86e9aab#\f8113689b1aac7b81a8e1c3345fef494\Microsoft.SqlServer.Smo.ni.dll

  Any Ideas?

  Alex

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  March 8, 2017 at 3:39 am

  #1932243

  Have you tried applying SP2?  Better still, why not go straight to SSMS 2016?

  John

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  March 8, 2017 at 6:31 am

  #1932276

  John Mitchell-245523 - Wednesday, March 8, 2017 3:39 AM

  Have you tried applying SP2?  Better still, why not go straight to SSMS 2016?

  John

  +1, unless the OP needs to connect to a SQL Server version that doesn't support.

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service