SQL Server 2012 Management Studio hangs
The actual solution in this case was a simple restart of the server.
I would recommend that this is the first thing that is tried if this is at all possible.
SQL Server Management Studio hanging every few seconds
Just some suggestions that might help.
You could try running SQL Profiler, and watch out for any lengthy calls to the database which might
make it hang.
Have you tried turning off intellisense? Options -> Text Editor -> Transact-SQL -> IntelliSense -> Untick Enable IntelliSense
Why does SQL Server Management Studio hang (Not Responding) when connecting to Amazon RDS?
Have you tried the latest SSMS releases? They include improvements to provide better support for SQL Servers running in the cloud. This may help resolve your issue.
Related Topics
Check Users in a Security Group in SQL Server
Postgres: Select All Row with Count of a Field Greater Than 1
How to Get Referenced Values from Another Table
Rails + Postgresql Ssl Decryption Failure
What Can Happen as a Result of Using (Nolock) on Every Select in SQL Server
Why Does Connect by Level on a Table Return Extra Rows
Repeating Rows Based on Column Value in Each Row
How to Convert Integer to Decimal in SQL Server Query
Sql Server 2005:Charindex Starting from The End
Sql Computation of Cosine Similarity
Sql Server 2008 Hierarchy Data Type Performance
Does Introducing Foreign Keys to MySQL Reduce Performance
Updating One Column Based on The Value of Another Column
Arel Causing Infinite Loop on Aggregation
Efficiently Duplicate Some Rows in Postgresql Table
Select Same Column from Multiple Tables Only Where Something = Something