Analyzing existing applications

If your existing applications experience blocking and deadlock problems, follow the steps below to analyze the problem:

  1. Check for deadlocks and lock contention:

  2. If the table uses allpages locking and has a clustered index, ensure that performance of the modified clustered index structure on data-only-locked tables will not hurt performance.

    See “Tables where clustered index performance must remain high”.

  3. If the table uses allpages locking, convert the locking scheme to datapages locking to determine whether it solves the concurrency problem.

  4. Re-run your concurrency tests. If concurrency is still an issue, change the locking scheme to datarows locking.