drdeadpan (vkat01-nospam@yahoo.com) writes:
> I asked the DBA to start the Server with options -T1204 and -T3605 and
> here's what I get. I need help deciphering this. This happens when we
> have 5 usrs performing concurrent actions and for the life of me cannot
> decipher this. WHat is a Node, what is the branch ?
> WHat are the ECIDs. I cannot even easily find out what process blocks
> what. Does anyone have any experience with these. ANy and all help will
> be appreaciated. I have posted the output of one of the many deadlocks
> encountered. Thanks

Deadlock graphs are unfortunately very difficult to read.

But what I can tell from your dump is that your deadlock involves
parallelism. ECID is a thread-id within a spid, and it seems that
some threads may be blocking each other.

When it says "PAG 7:1:405367" that's the resource being fought about.
7 is the database id, and 1 is the file id. Since this is page, the
last number is a page number. By using DBCC PAGE you can find out
which table the page belongs to. (But DBCC PAGE is not documented in
Books Online, and I don't remember the parameters. But a Google search
might find something.)

Parallelism is often more to harm than benefit in my experience. If
you can track down the query that SPID 61 submitted, an OPTION (MAXDOP 1)
at the end of that query, prevents parallelism. (MAXDOP = MAX Degree of
Parallelism.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp