sql server 数据库展开变慢
2023-09-11 14:14:21 时间
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 数据库分区分表
- sql server 使用SqlBulkCopy批量插入数据库
- sql server判断数据库、表、列、视图是否存在
- 关于SQL Server 数据库的备份
- 基于SQL Server数据库搭建主从复制实现读写分离实战演练
- SQL Server数据库专用管理员DAC连接方式
- C#各种扩展名文件存入sql server数据库及读取到本地文件
- 如何让Activiti-Explorer使用sql server数据库
- SQL Server数据库多种方式查找重复记录
- SQL SERVER服务器链接连接(即sql server的跨库连接)
- 如何让Activiti-Explorer使用sql server数据库
- [0] 数据库监测SQL Server Profiler
- 集差集 哈希表 比较数据库的照片和server画面上,将server垃圾上的图片删除
- 利用PowerUpSQL攻击SQL Server实例——本质上就是利用弱密码登录SQL server
- sql的介绍——SQL Server数据库管理系统
- 【SQL Server】数据库开发指南(三)面向数据分析的 T-SQL 编程技巧与实践
- [SQL] SQL Server远程链接MySql数据库(LinkedServer)