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
Last activity: Aug 10, 2023, 11:58 AM