SQLSERVER数据库优化配置
SQL Server开启READ_COMMITTED_SNAPSHOT --查询数据库状态 select name,user_access,user_access_desc, snapshot_isolation_state,snapshot_isolation_state_desc, is_read_committed_snapshot_on from sys.databases --设置数据库为SINGLE_USER模式,减少锁定时间 ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE dbname SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE dbname SET READ_COMMITTED_SNAPSHOT ON ALTER DATABASE dbname SET MULTI_USER
查询表使用行数
SELECT DISTINCT a.name , b.rows FROM sysobjects a , sysindexes b WHERE a.id = b.id AND a.type = 'u' AND b.rows>0 ORDER BY b.rows DESC
SQLServer加字段锁表
在设计编辑器中往中间加则会锁表,在末尾加不会锁表