|
Posted by Chung Leong on 07/29/06 22:14
Joshua Ruppert wrote:
> I'm a little confused about how to troubleshoot this from the DB side.
> The only way I see to avoid dead locks is to write all queries without
> any joins, or serialize the queries on the database. Is it possible to
> serialize some or all queries? I started setting up alerts to create
> log entries for deadlock situations, I'm now stumbling through how to
> send eMail from SQL Server (that's turned into an entirely new
> expedition). Is there any additional you would suggest for
> troubleshooting on the db side? Any experience with SQL Server 2000?
Have you tried the "log long query" option in the ODBC driver? If it
works as stated, it should give you some insight into what is causing
the process to hang.
Navigation:
[Reply to this message]
|