5
Views
2
Comments
Azure SQL Database isolation level

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.


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'

Rank: #61413

Hi CV.

thanks for your reply.

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

thanks :)

Yori.