VS2015 SQL Server Object Explorer Performance is Extemely Slow

Given my db has the following object counts:

72    SYSTEM_TABLE
41   VIEW
3    SQL_TABLE_VALUED_FUNCTION
16  SQL_STORED_PROCEDURE
3    SERVICE_QUEUE
4    SQL_INLINE_TABLE_VALUED_FUNCTION
29  USER_TABLE
7    PRIMARY_KEY_CONSTRAINT
17  INTERNAL_TABLE
5    SQL_SCALAR_FUNCTION

It takes about 10 minutes to expand the list of 29 user tables.  The query that produced this list ran for 7 seconds (which is acceptable). 

This may be related to the earlier post about not being able to edit ddl in SSDT VS 2015.

September 10th, 2015 5:52pm

Thank you very much. It seems the issue was with Azure and suddenly this issue and the editing DDL issue went away.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 3:51am

Why don't you use SSMS = SQL Server Management Studio instead?
September 11th, 2015 6:25am

Hi TJH99,

Since the issue is more related to SQL Server data tools, I would recommend you post the question in the SQL Server Data Tools forum. It is appropriate and more experts will assist you.


Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 6:49am

I did use SSMS as well and experienced the same sever degradation in performance .  Problem went away mysteriously as stated below.
September 12th, 2015 3:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics