0

SQL Server Management Studio 2014 and is drawing over 1 GB memory every time it is launched. Often the program becomes unresponsive. Even when no queries are running. I was using it yesterday with no problems. I don't believe that I made any changes that would impact Management Studio. Any thoughts?

bjurstrs
  • 949
  • 2
  • 7
  • 17
  • Any Add-ins installed? – Y.B. Jun 17 '16 at 16:32
  • nope. Its pretty much the default install of SSMS 2014 – bjurstrs Jun 17 '16 at 16:35
  • Does it do this if you don't connect to a server? (hit cancel on connect prompt) I find the Intellisense/Auto-Complete can cause lag until the server tables/columns are all cached. – Dave C Jun 17 '16 at 16:35
  • It seems to be only when I am connected to the Server. – bjurstrs Jun 17 '16 at 16:40
  • That's not typical behavior. Is it the same for any server you connect to? When it connects to an instance, it only does basic enumeration of the top level objects. Even if you have hundreds of databases in the instance and each database has thousands of objects, initial connection to the instance does not walk all the objects. Problem is likely somewhere else. Perhaps some logon trigger gone wild or metadata corruption. – SQLmojoe Jun 17 '16 at 17:18

0 Answers0