Deadlocking Error

[Jack]

I'm getting this error quite often at my site and I'm looking for a way to resolve it. Any help would be appreciated.

Thanks,

Jack

Microsoft OLE DB Provider for SQL Server error '80004005'
Your transaction (process ID #15) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction.

[MAK]

whenever your have a lot of tranasactions at your server and lot of select statement being executed from the website then u have to change
all the select statements on your website queries with NOLOCK.

this is solve most of the blocking on websites



------------
Jack at 5/8/2002 3:38:35 PM


I'm getting this error quite often at my site and I'm looking for a way to resolve it. Any help would be appreciated.

Thanks,

Jack

Microsoft OLE DB Provider for SQL Server error '80004005'
Your transaction (process ID #15) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction.

[Patience]

You may also need to run or trace or use the EM/Process Info to see what process ID #15 is doing each time is chosen as a deadlock victim. If it is a job, reschedule your jobs.

Good luck!


------------
MAK at 5/8/2002 3:43:58 PM

whenever your have a lot of tranasactions at your server and lot of select statement being executed from the website then u have to change
all the select statements on your website queries with NOLOCK.

this is solve most of the blocking on websites



------------
Jack at 5/8/2002 3:38:35 PM


I'm getting this error quite often at my site and I'm looking for a way to resolve it. Any help would be appreciated.

Thanks,

Jack

Microsoft OLE DB Provider for SQL Server error '80004005'
Your transaction (process ID #15) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction.

[Alfa]

Jack,

More tips for you.
Run Profiler to analyse what processes are clashing and which is taking precedence when you get the deadlocks.
You might be very unlucky and some software rewrites needed.
Deadlocks if they are happening frequently, are most likley caused by transactions locking up tables/databases in the opposite direction and clashing as they are both waiting for each other to unlock same column/table/row to get on with their job.
You might find it is just a timeout problem and adding an index in the right place might cure the problem.
First step, profiler to see what is causing the problem.

Good luck



------------
Jack at 5/8/2002 3:38:35 PM


I'm getting this error quite often at my site and I'm looking for a way to resolve it. Any help would be appreciated.

Thanks,

Jack

Microsoft OLE DB Provider for SQL Server error '80004005'
Your transaction (process ID #15) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction.