dynamicsusers: Simple query to check the recent blocking history

[Blog bot]

SQL Server 2005 keeps (some) history of the number and time that blocking occurred on indexes. This blog contains a query that queries this information to help identifying on which tables blocking happens most. The query shows accumulated numbers (no. of blocks, wait time, etc) since SQL Server was last restarted. The query does have some known in-accuracies. Also, the result needs to be interpreted: It may not point directly at which indexes need changing or disabling. See below for details about...(read more)

Подробнее... http://dynamicsuser.net/blogs/navsustatine...ng-history.aspx