Sample Header Ad - 728x90

Does SQL Server's serializable isolation level lock entire table

15 votes
2 answers
5749 views
Me and a colleague of mine discussed the implications of use of the serializable isolation level. He said it locked the entire table, but I disagreed to that telling him it potentially could but it tries to apply range locks and it doesn't apply true serialization as explained here: The Serializable Isolation Level . I can't find anything in the docs either for the "locks entire table": SET TRANSACTION ISOLATION LEVEL . The doc states a bunch of things regarding range locks, so in theory you could lock the entire table by simply having a range lock that locks the entire range of possible values in the table, but it doesn't lock the table. Am I completely wrong here? Does it in fact lock the entire table (or tables)?
Asked by mslot (427 rep)
Sep 28, 2019, 06:57 AM
Last activity: Sep 29, 2019, 06:28 PM