SMS slow when connecting to Azure SQL Server
I had the same problem and foud a work-around in this post: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8023437c-77e7-4bce-99ae-bfc717079749/slow-ssms-for-sql-azure?forum=ssdsgetstarted
Basically you have to close (not minimize) the property window. As long as the property window is open, SSMS constantly sends the same two sql commands to the DB.