Yori Koba
Rank: #61413
5Views
2Comments
Azure SQL Database isolation level
Question
Database
External Database

Hi.

I'm developing an application using Azure SQL Database for an external database.

According to the official reference, the isolation level of SQL Server is "Read Uncommitted".

Is Azure SQL Database "Read Uncommitted" as well?

If you know about this, please let me know.


0
0
on 5th Feb
Copy link to comment
CV SHARMA
Rank: #679

Hi Yori,

default isolation level for Azure SQL Database is RCSI – Read Committed Snapshot Isolation level. What if you decide to not use this and you want to turn it off and go back to read committed

ALTER DATABASE CRMDB SET READ_COMMITTED_SNAPSHOT OFF

 

ALTER DATABASE CRMDB SET ALLOW_SNAPSHOT_ISOLATION OFF

 

SELECT name, snapshot_isolation_state,snapshot_isolation_state_desc, is_read_committed_snapshot_on

FROM sys.databases

WHERE name = 'CRMDB'

1
0
on 5th Feb
Copy link to comment
Yori Koba
Rank: #61413

Hi CV.

thanks for your reply.

I was worried about dirty reads, but I understand that can use read committed.

thanks :)

Yori.

0
0
on 5th Feb
Copy link to comment