首页 > 数据库技术 > 详细

sql server 数据库展开变慢

时间:2017-11-27 18:38:01      阅读:424      评论:0      收藏:0      [点我收藏+]

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.

 

sql server 数据库展开变慢

原文:http://www.cnblogs.com/chucklu/p/7905309.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!