SQLServerCentral.com Articles tagged Locking

Use of Identity Property to Resolve Concurrency Issues

Fri, 22 Mar 2013 06:00:00 UT

This article describes how the identity property was used to resolve contention in a database

Large table cleanup with minimal locks

Tue, 06 Mar 2012 07:00:00 UT

How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

SQL Overview VI - Monitoring Process Locks

Fri, 22 Jul 2011 06:00:00 UT

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.

Use of Identity Property to Resolve Concurrency Issues

Fri, 22 Mar 2013 06:00:00 UT

This article describes how the identity property was used to resolve contention in a database

Troubleshoot Database Concurrency in SQL Server with sp_locks

Tue, 30 Nov 2010 07:00:00 UT

sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue.

SQL Overview VI - Monitoring Process Locks

Fri, 22 Jul 2011 06:00:00 UT

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.

Parallel Processing

Mon, 12 Oct 2009 06:00:00 UT

Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.

The DBA as Detective: Troubleshooting Locking and Blocking

Wed, 02 Sep 2009 06:00:00 UT

Rodney Landrum describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he passes on valuable tips learned from practical, and sometimes stressful, experience.

Using the Blocked Process Report in SQL Server 2005/2008

Thu, 30 Oct 2008 06:00:00 UT

When excessive blocking occurs in SQL, performance degrades. Learn how to use the Blocked Process Report to rapidly resolve excessive blocking scenarios in SQL Server 2005/2008.

Optimistic Locking in SQL Server using the ROWVERSION Data Type

Mon, 02 Jun 2008 06:00:00 UT

Using the default SQL Server READ COMMITTED isolation level, my application sometimes falls victim to the dreaded "lost update" condition where two of my users edit the same row for update but the user who submits his/her change last overwrites changes made by the other user. Is there a good way to check for this and prevent it?