sql server 数据库展开变慢

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/99bbcb47-d4b5-4ec0-9e91-b1a23a655844/ssms-2012-extremely-slow-expanding-databases?forum=sqltools

 

The Connect item you reference appears to be a behaviour caused by databases being set to AutoClose. 

This means that a database has to be started again before it can be examined. 

As you can imagine, if this is your case, then there will be delays.

Perhaps running this query would alert you to potential problems.

SELECT name, is_auto_close_on, is_auto_shrink_on 
FROM master.sys.databases AS dtb 
WHERE is_auto_close_on = 1 OR is_auto_shrink_on = 1
ORDER BY name

 

I would suggest turning autoclose off if it happens to be turned on. 

(Autoshrink likewise causes fragmentation, which can lead to other performance problems.)

Of course, this only matters if this describes your problem.

 

作者:Chuck Lu    GitHub