Sample Header Ad - 728x90

EF Queries Using Read Commited Though snapshot_isolation_state and is_read_committed_snapshot_on are ON

0 votes
1 answer
307 views
I am running this query, SELECT name , snapshot_isolation_state , is_read_committed_snapshot_on FROM sys.databases s name snapshot_isolation_state is_read_committed_snapshot_on master 1 0 tempdb 0 0 model 0 0 msdb 1 0 MyDB1 1 1 MyDB2 1 1 MyDB1 and MyDB2 is enabled snapshot but still all my Entity Framework queries are using, select transaction_isolation_level from sys.dm_exec_requests All sessions values are transaction_isolation_level=2 which means Read Committed. What can I do?
Asked by Imran Qadir Baksh - Baloch (1319 rep)
Aug 10, 2023, 06:44 AM
Last activity: Aug 10, 2023, 11:58 AM