Re: Problem with deadlocks

> What else can I do to bring the deadlock frequency count down more?

You can try one of three things...

1. Reduce your locking in your transaction if possible.
2. Make your transaction run as fast as possible.
3. Find out how your application is locking and change your application logic to remove the deadlock.

Have you tuned your write SQL statements (update/insert/delete)? A long running update statement can hold a lock longer than necessary if you can shorten the query time.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================