Locking

Technical Article

Transaction locking and row versioning guide

  • Article

In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

You rated this post out of 5. Change rating

2022-10-05

Blogs

What do client diagnostics in Cosmos DB mean?

By

This topic keeps coming up with my customers so the purpose of this blog...

Adding Row Numbers to a Query: #SQLNewBlogger

By

I realized that I hadn’t done much blogging on Window functions in T-SQL, and...

Adding Row Numbers to a Query: #SQLNewBlogger

By

I realized that I hadn’t done much blogging on Window functions in T-SQL, and...

Read the latest Blogs

Forums

FIFO and manufacturing ... how do I get the current cost?

By pietlinden

Sorry, more bakery stuff. Say I buy ingredients over time and I want to...

Linked server and trouble between manager and agent

By msimone

Hello, I have a problem and i don´t understand it. After to link a...

Starting to Estimate Disk Storage for Memory-Optimized Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting to Estimate Disk Storage...

Visit the forum

Question of the Day

Starting to Estimate Disk Storage for Memory-Optimized Tables

If I have durable memory-optimized tables, what is the starting point for estimating storage space?

See possible answers