优化SQLServer

由于SQLServer,数据文件mdf过大,造成系统异常卡

一. 更改隔离级别

ALTER DATABASE [B2EC] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;
ALTER DATABASE [B2EC] SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE [B2EC] SET MULTI_USER;


二. cursor threshold 改成0


https://technet.microsoft.com/zh-cn/library/ms175817(v=sql.100).aspx

原文地址:https://www.cnblogs.com/nov5026/p/6498042.html