Hi:
the proc ABC with just select statement to return a record set, which ran 4 minuts on SQL2000 SVR2000 with 8GB memory and 1000 DBS.

Due to above performance issue, it is moved to SQL2005 SVR2005 sp1 with 16 gb. Enterprise 64 bit. It runs only 18 seconds. However, once in a while, the following message appears:

Msg 1205, Level 13, State 52, Procedure ABC

Transaction (Process ID 877) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

With the same table structures and procs for every customer DB, we have moved 100 databases from the same SQL2000 SVR2000 to the same 2005 server SVR2005 without above errors. DBCC checkdb with 0 error.

thanks
-D