Link to home
Start Free TrialLog in
Avatar of cheryl9063
cheryl9063Flag for United States of America

asked on

xml in sql deadlock data

I have the text data below I created from running a trace on SQL Server 2008 r2. How do I get this data in seperate columns?



<deadlock-list>   <deadlock victim="processc808748">    <process-list>     <process id="processc808748" taskpriority="5" logused="0" waitresource="PAGE: 5:1:6612070" waittime="2046" ownerId="294595948" transactionname="UPDATE" lasttranstarted="2012-11-13T15:54:13.293" XDES="0x9ec2943b0" lockMode="U" schedulerid="1" kpid="6620" status="suspended" spid="123" sbid="0" ecid="0" priority="-5" trancount="2" lastbatchstarted="2012-11-13T15:54:13.293" lastbatchcompleted="2012-11-13T15:54:13.293" clientapp="HIE Process Import Linking Service" hostname="PMCOM1" hostpid="0" loginname="CFS\twservices" isolationlevel="read committed (2)" xactid="294595948" currentdb="5" lockTimeout="4294967295" clientoption1="538968096" clientoption2="128056">      <executionStack>       <frame procname="Ntier_CHCPA.HIE_PM.spAltIBChargesLinkModifiers" line="58" stmtstart="3914" stmtend="4184" sqlhandle="0x03000500b1096b3aeaae6201fda000000100000000000000">  UPDATE  HIE_PM.IB_Charges          SET     Import_Status = @Temp_ImportStatus          WHERE   Import_Status = @ImportStatus     </frame>      </executionStack>      <inputbuf>  Proc [Database Id = 5 Object Id = 980093361]    </inputbuf>     </process>     <process id="processc858988" taskpriority="5" logused="2416" waitresource="PAGE: 5:1:1721335" waittime="2049" ownerId="294595957" transactionname="user_transaction" lasttranstarted="2012-11-13T15:54:13.300" XDES="0x7945ca3b0" lockMode="IX" schedulerid="9" kpid="6440" status="suspended" spid="131" sbid="0" ecid="0" priority="-5" trancount="2" lastbatchstarted="2012-11-13T15:54:13.300" lastbatchcompleted="2012-11-13T15:54:13.300" clientapp="HIE Process Import Events Service" hostname="PMCOM1" hostpid="0" loginname="CFS\twservices" isolationlevel="read committed (2)" xactid="294595957" currentdb="5" lockTimeout="4294967295" clientoption1="538968096" clientoption2="128056">      <executionStack>       <frame procname="Ntier_CHCPA.HIE_PM.spAltAllIBTablePendtoNotImported" line="161" stmtstart="12760" stmtend="13108" sqlhandle="0x0300050084f4512cdaad6201fda000000100000000000000">  UPDATE  HIE_PM.IB_Charges with (rowlock)    SET Import_Status = @Import_Status_NotImported     WHERE Import_Status = @Import_Status_Pend and IB_Format_ID = @IB_Format_ID     </frame>      </executionStack>      <inputbuf>  Proc [Database Id = 5 Object Id = 743568516]    </inputbuf>     </process>    </process-list>    <resource-list>     <pagelock fileid="1" pageid="6612070" dbid="5" objectname="Ntier_CHCPA.HIE_PM.IB_Charges" id="lock5bb5b8680" mode="IX" associatedObjectId="72057640617246720">      <owner-list>       <owner id="processc858988" mode="IX"/>      </owner-list>      <waiter-list>       <waiter id="processc808748" mode="U" requestType="wait"/>      </waiter-list>     </pagelock>     <pagelock fileid="1" pageid="1721335" dbid="5" objectname="Ntier_CHCPA.HIE_PM.IB_Charges" id="lock417482e00" mode="U" associatedObjectId="72057640617246720">      <owner-list>       <owner id="processc808748" mode="U"/>      </owner-list>      <waiter-list>       <waiter id="processc858988" mode="IX" requestType="wait"/>      </waiter-list>     </pagelock>    </resource-list>   </deadlock>  </deadlock-list>
ASKER CERTIFIED SOLUTION
Avatar of Habib Pourfard
Habib Pourfard
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cheryl9063

ASKER

OK you are awesome..Thanks!