We have a C# process, Partner Synch, that sends some SQL to a SQL 2005 DB that times out about every three days or so. We know the SQL that times out,
the victim, of the .NET command timeout. It is attempting to update one table and seems to be blocked by another process. We’d like to set up a trace of some sort that tells us as much as possible about what process is doing the blocking at the time
of the timeout. Ideally, we’d like to know the SQL that is blocking our Partner Synch process, because then we could determine the C# or sproc responsible.
The blocking process ID is not too useful because we’d have trouble knowing what it corresponded to. Ideally, we’d like to see something