优化自建 MS Sql Server

1. 提高并发性和数据一致性

ALTER DATABASE MyDatabase
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;

ALTER DATABASE MyDatabase  
SET ALLOW_SNAPSHOT_ISOLATION ON  
  
ALTER DATABASE MyDatabase  
SET READ_COMMITTED_SNAPSHOT ON  

ALTER DATABASE MyDatabase
SET MULTI_USER;

2.调整服务器的并行配置