performance problem with MSDTC Transaction

Hello,
We are having a blocked processes problem,then we see sp_who2 active then
it's blocked by spid is -2...I know it's a MSDTC transaction.But is there
a way to see the sql behind the transaction..we cannot see the sql behind
the MSDTC transaction and we don't know what's causing the problem..
Any help on this appreciated..Using SQL Profiler you can get the DTC transaction ID so you can correlate
to each side.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.
"chinn" <chinn@.discussions.microsoft.com> wrote in message
news:02DA5A99-B21D-4FA7-AE96-AD911C43FDC1@.microsoft.com...
> Hello,
> We are having a blocked processes problem,then we see sp_who2 active then
> it's blocked by spid is -2...I know it's a MSDTC transaction.But is there
> a way to see the sql behind the transaction..we cannot see the sql behind
> the MSDTC transaction and we don't know what's causing the problem..
> Any help on this appreciated..|||Hello...I am having similar problems with SPID's of -2 causing locking, can
you give me more information please on how I should go about troubleshooting
what the actual transaction is. The client side is Weblogic using JDBC XA
Pool, MSDTC and SQL Server 2000.
Thank you
"Gert E.R. Drapers" wrote:
> Using SQL Profiler you can get the DTC transaction ID so you can correlate
> to each side.
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2005 All rights reserved.
> "chinn" <chinn@.discussions.microsoft.com> wrote in message
> news:02DA5A99-B21D-4FA7-AE96-AD911C43FDC1@.microsoft.com...
> > Hello,
> >
> > We are having a blocked processes problem,then we see sp_who2 active then
> > it's blocked by spid is -2...I know it's a MSDTC transaction.But is there
> > a way to see the sql behind the transaction..we cannot see the sql behind
> > the MSDTC transaction and we don't know what's causing the problem..
> >
> > Any help on this appreciated..
>
>