Why is SQL Server Object Explorer in Visual Studio so slow? : <p>I just created a new SQL Server Database in Azure and then opened it in Visual Studio 2015 using the link in the Azure Portal.  I had to add my IP to the firewall but otherwise the process went smoothly.</p>

<p>However, when I am trying to interact with the database server via SQL Server Object Explorer it is painfully slow.  Expanding any of the folders in my Database (e.g., <code>Tables</code> folder) takes 10 to 30 seconds.  The database is brand new, so the only things it has are whatever Azure creates when it instantiates a new DB.</p>

<p>This is the second Azure DB I have created and tried to view in Visual Studio and both have the same problem.  With the first one I thought maybe I did something wrong during setup but this time I made sure to do everything by the book.</p>

<p>Running actual queries against the DB from within Visual Studio (right click the DB, <code>New Query ...</code>, <code>select * from INFORMATION_SCHEMA.TABLES;</code>) is very fast, so it doesn't appear to be a problem with my connection to Azure.</p>

<p>Why is it so painfully slow?  What can I do to make it faster?</p>

<p>I am using Visual Studio 2015 Update 1 (<code>14.0.24720.00</code>) on Windows 10 (fully patched) and during database creation I checked the box to use the latest version.</p>
