add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE
@x xml;
SET
@x='<event name="blocked_process_report" package="sqlserver" timestamp="2022-11-06T14:38:50.569Z">
<data name="duration">
<value>20887000</value>
</data>
<data name="database_id">
<value>5</value>
</data>
<data name="object_id">
<value>0</value>
</data>
<data name="index_id">
<value>0</value>
</data>
<data name="lock_mode">
<value>3</value>
<text>S</text>
</data>
<data name="transaction_id">
<value>23200057</value>
</data>
<data name="resource_owner_type">
<value>0x00000001</value>
<text>LOCK</text>
</data>
<data name="blocked_process">
<value>
<blocked-process-report monitorLoop="191492">
<blocked-process>
<process id="process23696fb68c8" taskpriority="0" logused="0" waitresource="PAGE: 5:5:1476835 " waittime="20887" ownerId="23200057" transactionname="SELECT" lasttranstarted="2022-11-06T06:38:29.677" XDES="0x2369a9ebaa0" lockMode="S" schedulerid="5" kpid="5100" status="suspended" spid="57" sbid="0" ecid="1" priority="0" trancount="0" lastbatchstarted="2022-11-06T06:38:29.677" lastbatchcompleted="2022-11-06T06:38:22.943" lastattention="1900-01-01T00:00:00.943" clientapp="Microsoft SQL Server Management Studio - Query" hostname="NADASAVAGE" hostpid="20084" isolationlevel="read committed (2)" xactid="23200057" currentdb="5" currentdbname="StackOverflow2013" lockTimeout="4294967295" clientoption1="671090784" clientoption2="390200">
<executionStack>
<frame line="1" stmtend="108" sqlhandle="0x020000008d18260040e407ba48fc247b0cb6121c21c2cf2b0000000000000000000000000000000000000000" />
<frame line="1" stmtend="108" sqlhandle="0x02000000dd847b18dcaa4a09a89f56595186fcf91da8a7f70000000000000000000000000000000000000000" />
</executionStack>
There are multiple root elements. Line 1, position 137.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at ASP.index_aspx.PrettyXML(String XMLString)
   at ASP.index_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)