Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I eliminate or reduce locking?

SQL Server Performance Issues

How can I eliminate or reduce locking?

by  tlbroadbent  Posted    (Edited  )
Here are some resources that provide help with blocking issues in SQL Server.

Tips from Microsoft

INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problem
http://support.microsoft.com/support/kb/articles/Q224/4/53.ASP

Tips from SQL-Server-Performance.Com

Tips for Reducing SQL Server Locks
http://www.sql-server-performance.com/reducing_locks.asp

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK
http://www.sql-server-performance.com/lock_contention_tamed_article.asp

Tips from SWYNK.Com

Transactions, locking and concurrency in SQL Server
http://www.swynk.com/friends/sharma/locking.asp
http://www.swynk.com/friends/sharma/locking2.asp
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top