如何检测已启用READ_COMMITTED_SNAPSHOT? [英] How to detect READ_COMMITTED_SNAPSHOT is enabled?

问题描述

在MS SQL Server中，有一种方法可以检测是否通过T-SQL命令ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;

In MS SQL Server is there a way to detect whether a database has had its isolation level set via the T-SQL command ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;

在T-SQL或通过Management Studio的GUI中，我找不到一种简单的方法来检测到这一点.

I cannot find a simple way to detect this in either T-SQL or via the Management Studio's GUI.

TIA

推荐答案

SELECT is_read_committed_snapshot_on FROM sys.databases 
WHERE name= 'YourDatabase'

返回值:

• 1 :READ_COMMITTED_SNAPSHOT选项为 ON . READ COMMITTED隔离级别下的读取操作基于快照扫描，并且不获取锁定.
• 0 (默认):READ_COMMITTED_SNAPSHOT选项为 OFF .在READ COMMITTED隔离级别下的读取操作使用共享(S)锁

• 1: READ_COMMITTED_SNAPSHOT option is ON. Read operations under the READ COMMITTED isolation level are based on snapshot scans and do not acquire locks.
• 0 (default): READ_COMMITTED_SNAPSHOT option is OFF. Read operations under the READ COMMITTED isolation level use Shared (S) locks.

这篇关于如何检测已启用READ_COMMITTED_SNAPSHOT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！