Hands-On SQL Server 2000 Troubleshooting: Locking and Blocking

Hands-On SQL Server 2000 Troubleshooting: Locking and Blocking
by Kalen Delaney
E-Book
Copyright 2003
NetImpress

One of the least appreciated aspects of SQL Server performance tuning is the negative affect of locking and blocking. While some degree of locking and blocking is expected, excessive amounts can significantly hurt performance. In fact, I recently was helping a client identify a SQL Server-related performance problem. As part of the discovery process, I found out that their SQL Server was consistently creating over 200,000 new locks per second. And this was for a database with a maximum of 50 simultaneous users. Obviously, they have locking and blocking issues.

If you are one of those DBAs or developers who like to know the internal workings of how a product like SQL Server works, then this new e-book from Kalen Delaney (the author of Inside SQL Server 2000) is right up your alley. It provides the most detailed and comprehensive look at SQL Server 2000 locking and blocking available. Here's what this book covers in 89 pages:

• Transactions

• Locking Basics

• Locking Internals

• Controlling Locking

• Troubleshooting Blocking Problems

• How Does SQL Server Handle Deadlocks

• Application Deadlock

• Recommendations

Besides telling you everything there is possibly to know about SQL Server locks and blocking, the book comes with many examples in the form of SQL scripts that you can run as you read the book. These examples greatly enhances the learning process.

If you are serious about performance tuning, and like reading juicy, technical details, then reading this book should be your goal. In fact, mastering the content of this book will put you heads and shoulders above the knowledge possessed by the typical SQL Server DBA.