Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking | Kalen Delaney

book: Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking | Kalen Delaney

books:

Hands-On SQL Serve...

	Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking Kalen Delaney NetImpress, 2002 average customer review:based on 1 review view larger image
	for more information click here

In this first installment of the hands-on series, SQL Server guru Kalen Delaney walks you through troubleshooting your SQL Server performance problems. In this installment, she dives deep into locking and blocking: what causes them, how to fix them when they are a problem, and how to look into the system tables to troubleshoot problems. The hands-on series has lots of sample code to get you started and debugging your own performance problems quickly! Tech edited by Itzik Ben-Gan.

Worth the money if you want to understand locking

This 90 page pamphlet is a great choice if you want to understand how to pinpoint and analyze locking. The author delves into considerable detail on locking, isolation levels, monitoring, deadlocks, and lock escalation.

The author has worked for Microsoft for many years and she knows her stuff. It is apparent she is intimately familiar with inner workings of SQL Architecture unlike many SQL book authors.

Although this pamphlet is great in deciphering and understanding locking, it lacks suggestions on how to reduce locking problems.

Sure, many of the locking issues can be resolved by creating an index, but the author hardly mentions even that as a solution.

The pamphlet could have been much better if the author added a chapter on which type of indexes should be created on what types of columns. Also, a lesson on statistics, how it is used, and how it can be best manipulated by DBAs are not mentioned at all.

I look forward to Kalen's next book on SQL 2005 which I am sure will be detailed and insightful.

for more information click here

products you might be interested in