Which isolation level should you use?

You use Microsoft SQL Server 2012 to write code fora transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space.
You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?

You use Microsoft SQL Server 2012 to write code fora transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space.
You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?

A.
SERIALIZABLE

B.
SNAPSHOT

C.
READ COMMITTED SNAPSHOT

D.
REPEATABLE READ

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

John

John

I almost think none of these are good answers. SNAPSHOT uses tempdb a lot. The SERIALIZABLE and REPEATABLE READ block the writing queries. So…

Reply

Brian K

Brian K

Best answer is C. READ COMMITTED SNAPSHOT consumes less space in TempDB than SNAPSHOT.

Reply