Troubleshooting high lock wait time and lock time-out

Published 05-19-2021 09:35 AM 972 Views
Microsoft

 

Locks are held in the database to ensure data consistency. If there are errors due to lock time-out or performance issues due to lock waits, the recommendation is to review the transactions that are involved in the locks to check if it is possible to change anything in their logic or isolation level to improve concurrency and avoid the blocks. Blocks can also be caused by transactions taking longer than expected and, in this case, it may require query tuning.

 

We can use T-SQL while the issue is happening to identify the queries involved in the block and the applications that are running them.

 

With the query below, we can see the sessions involved in the block, last query they ran, and which one is the head of the block. It might already give us enough information to identify where the issue is:

 

--Blocking tree

 

SET NOCOUNT ON
GO
SELECT SPIDBLOCKEDREPLACE (REPLACE (T.TEXTCHAR(10), ' '), CHAR (13), ' ' ) AS BATCH
INTO #T
FROM sys.sysprocesses R CROSS APPLY sys.dm_exec_sql_text(R.SQL_HANDLET
GO
WITH BLOCKERS (SPIDBLOCKEDLEVELBATCH)
AS
(
SELECT SPID,
BLOCKED,
CAST (REPLICATE ('0'4-LEN (CAST (SPID AS VARCHAR))) + CAST (SPID AS VARCHARAS VARCHAR (1000)) AS LEVEL,
BATCH FROM #T R
WHERE (BLOCKED OR BLOCKED SPID)
AND EXISTS (
SELECT FROM #T R2 WHERE R2.BLOCKED R.SPID AND R2.BLOCKED <> R2.SPID)
UNION ALL
SELECT R.SPID,
R.BLOCKED,
CAST (BLOCKERS.LEVEL RIGHT (CAST ((1000 R.SPIDAS VARCHAR (100)), 4AS VARCHAR (1000)) AS LEVEL,
R.BATCH FROM #T AS R
INNER JOIN BLOCKERS ON R.BLOCKED BLOCKERS.SPID WHERE R.BLOCKED AND R.BLOCKED <> R.SPID
)
SELECT N'    ' REPLICATE (N'|         'LEN (LEVEL)/1) +
CASE WHEN (LEN(LEVEL)/10
THEN 'HEAD -  '
ELSE '|------  ' END
CAST (SPID AS NVARCHAR (10)) + N' ' BATCH AS BLOCKING_TREE
FROM BLOCKERS ORDER BY LEVEL ASC
GO
DROP TABLE #T
GO

 

If the information provided by the last query is not enough and we have to look deeper into the sessions that are part of the block, we can run the query below:

 

--Details about the sessions that are blocking and being blocked:

 

SELECT current_timestamp as [CURRENT_TIMESTAMP]

       , DB_NAME(dtl.resource_database_id) AS database_name

       , req.session_id AS blocked_sessionID

       , ses.program_name blocked_programName

       , ses.host_name blocked_hostname

       , ses.login_name blocked_login

       , CASE ses.transaction_isolation_level

              WHEN 1 THEN 'ReadUncomitted'

              WHEN 2 THEN 'ReadCommitted'

              WHEN 3 THEN 'Repeatable'

              WHEN 4 THEN 'Serializable'

              WHEN 5 THEN 'Snapshot'

       END blocked_isolation_level

       , REPLACE(REPLACE(sqltext.TEXT, CHAR(13), ' '), CHAR(10), ' ') AS blocked_last_query

       , req.status AS [blocked_status]

       , req.command AS blocked_command

       , req.cpu_time AS blocked_cpuTime

       , req.total_elapsed_time AS blocked_totalElapsedTime

       , blocked_tran.transaction_id blocked_transaction_id

       , osw.blocking_session_id AS blocker_SessionID

       , blocker_ses.program_name blocker_programName

       , blocker_ses.host_name blocker_hostName

       , blocker_ses.login_name blocker_login

       , CASE blocker_ses.transaction_isolation_level

              WHEN 1 THEN 'ReadUncomitted'

              WHEN 2 THEN 'ReadCommitted'

              WHEN 3 THEN 'Repeatable'

              WHEN 4 THEN 'Serializable'

              WHEN 5 THEN 'Snapshot'

       END blocker_isolation_level

       , REPLACE(REPLACE(iif(blocker_sqltext.TEXT is NULL,blocker_sqltext2.event_info,blocker_sqltext.TEXT), CHAR(13), ' '), CHAR(10), ' ') AS blocker_last_query

       , blocker_req.status AS [blocker_status]

       , blocker_req.command AS blocker_command

       , blocker_req.cpu_time AS blocker_cpuTime

       , blocker_req.total_elapsed_time AS blocker_totalElapsedTime

       , blocker_proc.lastwaittype blocker_last_waittype

       , blocker_proc.last_batch blocker_last_batch

       , blocker_proc.open_tran blocker_open_tran

       , blocker_tran.transaction_id blocker_transaction_id

       , blocker_proc.cmd blocker_command

       , dtl.request_mode AS lockRequestMode

       , dtl.resource_type AS lockResourceType

       , dtl.resource_subtype AS lockResourceSubType

       , osw.wait_type AS taskWaitType

       , osw.resource_description AS taskResourceDescription

       , osw.wait_duration_ms

FROM sys.dm_exec_requests req

INNER JOIN sys.dm_exec_sessions ses on ses.session_id = req.session_id

CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) AS sqltext

INNER JOIN sys.dm_tran_locks dtl on dtl.request_session_id = req.session_id

INNER JOIN sys.dm_os_waiting_tasks osw on osw.session_id = req.session_id

LEFT JOIN sys.dm_tran_session_transactions blocked_tran on blocked_tran.session_id =req.session_id

INNER JOIN dbo.sysprocesses blocker_proc on osw.blocking_session_id = blocker_proc.spid

LEFT JOIN sys.dm_exec_requests blocker_req on blocker_req.session_id = osw.blocking_session_id

LEFT JOIN sys.dm_exec_sessions blocker_ses on blocker_ses.session_id = osw.blocking_session_id

LEFT JOIN sys.dm_tran_session_transactions blocker_tran on blocker_tran.session_id =osw.blocking_session_id

OUTER APPLY sys.dm_exec_sql_text(blocker_req.sql_handle) AS blocker_sqltext

OUTER APPLY sys.dm_exec_input_buffer(osw.blocking_session_id,0) as blocker_sqltext2;

 

 

This query will provide information about the last queries on both sides, the isolation level of each and if they are inside a transaction.

 

Locks are held for the duration of the transaction (between commits/rollbacks), so the lock might be being held due to a previous query of the current transaction. Said that, there may be cases in which the block does not make sense when looking at both sessions last query, but it does when we look at the whole transaction. However, we cannot see the previous queries the transaction ran using T-SQL.

 

In the cases where the blocks are happening due to a lock acquired for a previous statement, we can use the query below to see which locks are being held by the sessions involved in the block. It won’t give us the previous queries in the transactions, but it might help us understand why the block is happening and assist in the investigation.

 

 

--Details about the locks that are being held by the sessions that are blocking and being blocked:

 

select DB_NAME(locks.resource_database_id) AS database_name

 , locks.request_session_id

 , locks.resource_type, locks.resource_subtype

 , locks.resource_description

 , locks.resource_associated_entity_id

 , locks.resource_lock_partition

 , locks.request_mode

 , locks.request_type

 , locks.request_status

 , locks.request_reference_count

 , locks.request_lifetime

 , locks.request_exec_context_id

 , locks.request_request_id

 , locks.request_owner_type

FROM sys.dm_exec_requests req

INNER JOIN sys.dm_os_waiting_tasks osw on osw.session_id = req.session_id

INNER JOIN sys.dm_tran_locks locks on osw.blocking_session_id = locks.request_session_id or (osw.session_id = locks.request_session_id and osw.blocking_session_id is not null)

order by locks.request_session_id;

 

 

For Azure SQL Database, if the database has auditing enabled in the Portal, we can find all the queries that were run by the transaction in the audit logs by filtering by session ID and transaction ID provided in the second query.

 

For both Azure SQL Database and Azure SQL Managed Instance, we can create an XEvents session to see which queries are being run by the applications and filter by the transaction ID and session returned by the second query.

 

Both XEvents and Auditing will only assist in the investigation of locks that happened after they were enabled/started.

 

Examples:

 

1. Using Extended Events:

 

For this example, I created an XEvents session in a Managed Instance for the events sql_statement_starting and sql_statement_completed filtering by the database name and adding the global fields sessionID and transaction_id. You may also want to include other global fields to help you in the investigation, such as client_app_name, client_hostname and username.

 

Note: For more information about XEvents, please refer to the extended events documentation.

 

After the Extended Events is active, we have a block in our database with the following blocking tree:

 

Thamires_Lemes_1-1621439559912.png

 

As you can see, the head (session 98) last statement was an alter in the table Person and It is blocking the session 97 (insert in the table Person), which we can understand just looking at the queries.

 

However, the session 97 last statement was an insert into the table Person and It is blocking the session 115, that is trying to insert into the table Person2. If it is a different table, how can they this block happen?

 

We can understand when we look at the information collected by the XEvents:

 

Thamires_Lemes_2-1621439585985.png

 

We see the session 97 ran 2 queries in this same transaction (same transaction_id) and the first one was an alter in the table Person2.

 

It may be difficult to find the information right away if there is high activity on the database, so you can filter by the session_id and transaction_id, provided by the second query in this article to find all the statements that were executed within the same transaction.

 

2.  Using Azure SQL DB Auditing

 

If you have auditing enabled for your Azure SQL DB server/database, you can use the audit log to see the statements that were run by the transaction(s).

 

If we have the same scenario as the previous example, but now in an Azure SQL DB with auditing enabled:

 

Thamires_Lemes_3-1621439607209.png

 

As you can see above, the head (session 102) last statement was an alter in the table Person and It is locking the session 104 (insert in the table Person), which we can understand just looking at the queries.

 

However, the session 104 which last statement was the insert into Person is blocking the session 100 that is trying to insert into the table Person2. If it is a different table, how can they this block happen?

 

If we open the audit log and add the columns session_id and transaction_id, we can see the session 104 ran in this same transaction (same transaction_id) an alter in the table Person2:

 

Thamires_Lemes_4-1621439622694.png

 

We cannot see in the audit log the statements that are blocked, because it only shows the statements that have been completed. We can use the session_id and transaction_id returned by the second query of this article to filter the audit information and see the previous queries ran by the transaction(s).

 

References:

https://blog.sqlauthority.com/2015/07/07/sql-server-identifying-blocking-chain-using-sql-scripts/

%3CLINGO-SUB%20id%3D%22lingo-sub-2368875%22%20slang%3D%22en-US%22%3ETroubleshooting%20high%20lock%20wait%20time%20and%20lock%20time-out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2368875%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22WordSection1%22%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3ELocks%20are%20held%20in%20the%20database%20to%20ensure%20data%20consistency.%20If%20there%20are%20errors%20due%20to%20lock%20time-out%20or%20performance%20issues%20due%20to%20lock%20waits%2C%20the%20recommendation%20is%20to%20review%20the%20transactions%20that%20are%20involved%20in%20the%20locks%20to%20check%20if%20it%20is%20possible%20to%20change%20anything%20in%20their%20logic%20or%20isolation%20level%20to%20improve%20concurrency%20and%20avoid%20the%20blocks.%20Blocks%20can%20also%20be%20caused%20by%20transactions%20taking%20longer%20than%20expected%20and%2C%20in%20this%20case%2C%20it%20may%20require%20query%20tuning.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EWe%20can%20use%20T-SQL%20while%20the%20issue%20is%20happening%20to%20identify%20the%20queries%20involved%20in%20the%20block%20and%20the%20applications%20that%20are%20running%20them.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EWith%20the%20query%20below%2C%20we%20can%20see%20the%20sessions%20involved%20in%20the%20block%2C%20last%20query%20they%20ran%2C%20and%20which%20one%20is%20the%20head%20of%20the%20block.%20It%20might%20already%20give%20us%20enough%20information%20to%20identify%20where%20the%20issue%20is%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20class%3D%22MsoTableGrid%22%20style%3D%22border-collapse%3A%20collapse%3B%20border%3A%20none%3B%22%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22623%22%20valign%3D%22top%22%20style%3D%22width%3A%20467.5pt%3B%20border%3A%20solid%20windowtext%201.0pt%3B%20padding%3A%200mm%205.4pt%200mm%205.4pt%3B%22%3E%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20green%3B%22%3E--Blocking%20tree%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESET%20NOCOUNT%20ON%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EGO%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKED%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ET.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETEXT%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E10%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E13%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23363b3f%3B%20background%3A%20%23EDF0F2%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23363b3f%3B%20background%3A%20%23EDF0F2%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBATCH%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EINTO%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23434343%3B%22%3E%23T%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esys.sysprocesses%20R%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ECROSS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EAPPLY%20sys.dm_exec_sql_text%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.SQL_HANDLE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ET%3CBR%20%2F%3EGO%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWITH%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKERS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKED%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ELEVEL%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBATCH%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKED%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLICATE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'0'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E4%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E-%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ELEN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20VARCHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)))%20%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20VARCHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20VARCHAR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E1000%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E))%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20LEVEL%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBATCH%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23434343%3B%22%3E%23T%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHERE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E0%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EOR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3CBR%20%2F%3EAND%20EXISTS%20(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E*%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23434343%3B%22%3E%23T%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER2%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHERE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER2.BLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.SPID%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EAND%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER2.BLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%26lt%3B%26gt%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER2.SPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EUNION%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EALL%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.SPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.BLOCKED%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKERS.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ELEVEL%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ERIGHT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E((%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E1000%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.SPID%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20VARCHAR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E100%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E))%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E4%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20VARCHAR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E1000%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E))%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20LEVEL%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.BATCH%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23434343%3B%22%3E%23T%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EINNER%20JOIN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKERS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EON%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.BLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKERS.SPID%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHERE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.BLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%26gt%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E0%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EAND%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.BLOCKED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%26lt%3B%26gt%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ER.SPID%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3EN'%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B'%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLICATE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3EN'%7C%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ELEN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ELEVEL%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2F%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E4%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E-%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E1%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%20%2B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECASE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ELEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ELEVEL%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2F%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E4%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E-%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E1%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E0%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'HEAD%20-%26nbsp%3B%26nbsp%3B'%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EELSE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%7C------%26nbsp%3B%26nbsp%3B'%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EEND%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3ECAST%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3ESPID%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%20NVARCHAR%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E10%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E))%20%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3EN'%20'%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBATCH%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKING_TREE%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EBLOCKERS%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EORDER%20BY%20LEVEL%20ASC%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EGO%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EDROP%20TABLE%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23434343%3B%22%3E%23T%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3EGO%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIf%20the%20information%20provided%20by%20the%20last%20query%20is%20not%20enough%20and%20we%20have%20to%20look%20deeper%20into%20the%20sessions%20that%20are%20part%20of%20the%20block%2C%20we%20can%20run%20the%20query%20below%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20class%3D%22MsoTableGrid%22%20style%3D%22border-collapse%3A%20collapse%3B%20border%3A%20none%3B%22%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22623%22%20valign%3D%22top%22%20style%3D%22width%3A%20467.5pt%3B%20border%3A%20solid%20windowtext%201.0pt%3B%20padding%3A%200mm%205.4pt%200mm%205.4pt%3B%22%3E%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20green%3B%22%3E--Details%20about%20the%20sessions%20that%20are%20blocking%20and%20being%20blocked%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ESELECT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Ecurrent_timestamp%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eas%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20%5BCURRENT_TIMESTAMP%5D%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EDB_NAME%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Edtl%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_database_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Edatabase_name%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_sessionID%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Eprogram_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_programName%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Ehost_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_hostname%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Elogin_name%20blocked_login%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECASE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etransaction_isolation_level%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%201%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'ReadUncomitted'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%202%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'ReadCommitted'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%203%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Repeatable'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%204%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Serializable'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%205%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Snapshot'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EEND%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_isolation_level%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esqltext%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETEXT%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E13%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E10%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_last_query%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Estatus%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20%5Bblocked_status%5D%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ecommand%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_command%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ecpu_time%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_cpuTime%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etotal_elapsed_time%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_totalElapsedTime%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_tran%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etransaction_id%20blocked_transaction_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_SessionID%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Eprogram_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_programName%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Ehost_name%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_hostName%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Elogin_name%20blocker_login%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECASE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etransaction_isolation_level%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%201%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'ReadUncomitted'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%202%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'ReadCommitted'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%203%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Repeatable'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%204%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Serializable'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EWHEN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%205%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETHEN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'Snapshot'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EEND%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_isolation_level%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EREPLACE%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3Eiif%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocker_sqltext%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETEXT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Eis%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ENULL%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocker_sqltext2%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eevent_info%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocker_sqltext%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ETEXT%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E13%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3ECHAR%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E10%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%2C%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20red%3B%22%3E'%20'%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_last_query%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Estatus%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20%5Bblocker_status%5D%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ecommand%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_command%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ecpu_time%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_cpuTime%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etotal_elapsed_time%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_totalElapsedTime%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Elastwaittype%20blocker_last_waittype%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Elast_batch%20blocker_last_batch%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eopen_tran%20blocker_open_tran%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_tran%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Etransaction_id%20blocker_transaction_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ecmd%20blocker_command%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dtl%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_mode%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20lockRequestMode%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dtl%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_type%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20lockResourceType%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dtl%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_subtype%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20lockResourceSubType%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ewait_type%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20taskWaitType%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_description%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20taskResourceDescription%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ewait_duration_ms%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_requests%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_sessions%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ECROSS%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EAPPLY%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_sql_text%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ereq%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Esql_handle%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20sqltext%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_tran_locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dtl%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dtl%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_os_waiting_tasks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_tran_session_transactions%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_tran%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocked_tran%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Ereq%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20dbo%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esysprocesses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_proc%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Espid%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_requests%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_sessions%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_ses%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3ELEFT%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_tran_session_transactions%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_tran%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_tran%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eosw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EOUTER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EAPPLY%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_sql_text%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocker_req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Esql_handle%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_sqltext%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EOUTER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EAPPLY%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_input_buffer%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eosw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E0%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eas%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20blocker_sqltext2%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EThis%20query%20will%20provide%20information%20about%20the%20last%20queries%20on%20both%20sides%2C%20the%20isolation%20level%20of%20each%20and%20if%20they%20are%20inside%20a%20transaction.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3ELocks%20are%20held%20for%20the%20duration%20of%20the%20transaction%20(between%20commits%2Frollbacks)%2C%20so%20the%20lock%20might%20be%20being%20held%20due%20to%20a%20previous%20query%20of%20the%20current%20transaction.%20Said%20that%2C%20there%20may%20be%20cases%20in%20which%20the%20block%20does%20not%20make%20sense%20when%20looking%20at%20both%20sessions%20last%20query%2C%20but%20it%20does%20when%20we%20look%20at%20the%20whole%20transaction.%20However%2C%20we%20cannot%20see%20the%20previous%20queries%20the%20transaction%20ran%20using%20T-SQL.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIn%20the%20cases%20where%20the%20blocks%20are%20happening%20due%20to%20a%20lock%20acquired%20for%20a%20previous%20statement%2C%20we%20can%20use%20the%20query%20below%20to%20see%20which%20locks%20are%20being%20held%20by%20the%20sessions%20involved%20in%20the%20block.%20It%20won%E2%80%99t%20give%20us%20the%20previous%20queries%20in%20the%20transactions%2C%20but%20it%20might%20help%20us%20understand%20why%20the%20block%20is%20happening%20and%20assist%20in%20the%20investigation.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20class%3D%22MsoTableGrid%22%20style%3D%22border-collapse%3A%20collapse%3B%20border%3A%20none%3B%22%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22623%22%20valign%3D%22top%22%20style%3D%22width%3A%20467.5pt%3B%20border%3A%20solid%20windowtext%201.0pt%3B%20padding%3A%200mm%205.4pt%200mm%205.4pt%3B%22%3E%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20green%3B%22%3E--Details%20about%20the%20locks%20that%20are%20being%20held%20by%20the%20sessions%20that%20are%20blocking%20and%20being%20blocked%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eselect%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20fuchsia%3B%22%3EDB_NAME%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Elocks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_database_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E)%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EAS%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Edatabase_name%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_session_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_type%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_subtype%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_description%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_associated_entity_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eresource_lock_partition%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_mode%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_type%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_status%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_reference_count%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_lifetime%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_exec_context_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_request_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_owner_type%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3EFROM%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_exec_requests%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_os_waiting_tasks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20req%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EINNER%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3EJOIN%3C%2FSPAN%3E%20%3CFONT%20color%3D%22%23008000%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Esys%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20lime%3B%22%3Edm_tran_locks%3C%2FSPAN%3E%3C%2FFONT%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eon%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Eor%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E(%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eosw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Esession_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Eand%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20osw%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Eblocking_session_id%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Eis%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Enot%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3Enull)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eorder%3C%2FSPAN%3E%20%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20blue%3B%22%3Eby%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%20locks%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3Erequest_session_id%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20gray%3B%22%3E%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%20line-height%3A%20normal%3B%20text-autospace%3A%20none%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%209.5pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EFor%20%3CU%3EAzure%20SQL%20Database%2C%3C%2FU%3E%20if%20the%20database%20has%20auditing%20enabled%20in%20the%20Portal%2C%20we%20can%20find%20all%20the%20queries%20that%20were%20run%20by%20the%20transaction%20in%20the%20audit%20logs%20by%20filtering%20by%20session%20ID%20and%20transaction%20ID%20provided%20in%20the%20second%20query.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EFor%20both%20%3CU%3EAzure%20SQL%20Database%3C%2FU%3E%20and%20%3CU%3EAzure%20SQL%20Managed%20Instance%3C%2FU%3E%2C%20we%20can%20create%20an%20XEvents%20session%20to%20see%20which%20queries%20are%20being%20run%20by%20the%20applications%20and%20filter%20by%20the%20transaction%20ID%20and%20session%20returned%20by%20the%20second%20query.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EBoth%20XEvents%20and%20Auditing%20will%20only%20assist%20in%20the%20investigation%20of%20locks%20that%20happened%20after%20they%20were%20enabled%2Fstarted.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSTRONG%3EExamples%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E1.%20Using%20Extended%20Events%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EFor%20this%20example%2C%20I%20created%20an%20XEvents%20session%20in%20a%20Managed%20Instance%20for%20the%20events%20sql_statement_starting%20and%20sql_statement_completed%20filtering%20by%20the%20database%20name%20and%20adding%20the%20global%20fields%20sessionID%20and%20transaction_id.%20You%20may%20also%20want%20to%20include%20other%20global%20fields%20to%20help%20you%20in%20the%20investigation%2C%20such%20as%20client_app_name%2C%20client_hostname%20and%20username.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3ENote%3A%20For%20more%20information%20about%20XEvents%2C%20please%20refer%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fextended-events%2Fextended-events%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eextended%20events%20documentation%3C%2FA%3E.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EAfter%20the%20Extended%20Events%20is%20active%2C%20we%20have%20a%20block%20in%20our%20database%20with%20the%20following%20blocking%20tree%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Thamires_Lemes_1-1621439559912.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281859i44C5D2032B6D716B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Thamires_Lemes_1-1621439559912.png%22%20alt%3D%22Thamires_Lemes_1-1621439559912.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EAs%20you%20can%20see%2C%20the%20head%20(session%2098)%20last%20statement%20was%20an%20alter%20in%20the%20table%20Person%20and%20It%20is%20blocking%20the%20session%2097%20(insert%20in%20the%20table%20Person)%2C%20which%20we%20can%20understand%20just%20looking%20at%20the%20queries.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EHowever%2C%20the%20session%2097%20last%20statement%20was%20an%20insert%20into%20the%20table%20Person%20and%20It%20is%20blocking%20the%20session%20115%2C%20that%20is%20trying%20to%20insert%20into%20the%20table%20Person2.%20If%20it%20is%20a%20different%20table%2C%20how%20can%20they%20this%20block%20happen%3F%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EWe%20can%20understand%20when%20we%20look%20at%20the%20information%20collected%20by%20the%20XEvents%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Thamires_Lemes_2-1621439585985.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281860iCE1F25227B1A3B63%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Thamires_Lemes_2-1621439585985.png%22%20alt%3D%22Thamires_Lemes_2-1621439585985.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EWe%20see%20the%20session%2097%20ran%202%20queries%20in%20this%20same%20transaction%20(same%20transaction_id)%20and%20the%20first%20one%20was%20an%20alter%20in%20the%20table%20Person2.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIt%20may%20be%20difficult%20to%20find%20the%20information%20right%20away%20if%20there%20is%20high%20activity%20on%20the%20database%2C%20so%20you%20can%20filter%20by%20the%20session_id%20and%20transaction_id%2C%20provided%20by%20the%20second%20query%20in%20this%20article%20to%20find%20all%20the%20statements%20that%20were%20executed%20within%20the%20same%20transaction.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E2.%26nbsp%3B%20Using%20Azure%20SQL%20DB%20Auditing%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIf%20you%20have%20auditing%20enabled%20for%20your%20Azure%20SQL%20DB%20server%2Fdatabase%2C%20you%20can%20use%20the%20audit%20log%20to%20see%20the%20statements%20that%20were%20run%20by%20the%20transaction(s).%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIf%20we%20have%20the%20same%20scenario%20as%20the%20previous%20example%2C%20but%20now%20in%20an%20Azure%20SQL%20DB%20with%20auditing%20enabled%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Thamires_Lemes_3-1621439607209.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281862iF2115ED6F10CA65E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Thamires_Lemes_3-1621439607209.png%22%20alt%3D%22Thamires_Lemes_3-1621439607209.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EAs%20you%20can%20see%20above%2C%20the%20head%20(session%20102)%20last%20statement%20was%20an%20alter%20in%20the%20table%20Person%20and%20It%20is%20locking%20the%20session%20104%20(insert%20in%20the%20table%20Person)%2C%20which%20we%20can%20understand%20just%20looking%20at%20the%20queries.%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EHowever%2C%20the%20session%20104%20which%20last%20statement%20was%20the%20insert%20into%20Person%20is%20blocking%20the%20session%20100%20that%20is%20trying%20to%20insert%20into%20the%20table%20Person2.%20If%20it%20is%20a%20different%20table%2C%20how%20can%20they%20this%20block%20happen%3F%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EIf%20we%20open%20the%20audit%20log%20and%20add%20the%20columns%20session_id%20and%20transaction_id%2C%20we%20can%20see%20the%20session%20104%20ran%20in%20this%20same%20transaction%20(same%20transaction_id)%20an%20alter%20in%20the%20table%20Person2%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Thamires_Lemes_4-1621439622694.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281863i662C3335FDA315E4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Thamires_Lemes_4-1621439622694.png%22%20alt%3D%22Thamires_Lemes_4-1621439622694.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%20lia-indent-padding-left-30px%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EWe%20cannot%20see%20in%20the%20audit%20log%20the%20statements%20that%20are%20blocked%2C%20because%20it%20only%20shows%20the%20statements%20that%20have%20been%20completed.%20We%20can%20use%20the%20session_id%20and%20transaction_id%20returned%20by%20the%20second%20query%20of%20this%20article%20to%20filter%20the%20audit%20information%20and%20see%20the%20previous%20queries%20ran%20by%20the%20transaction(s).%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3EReferences%3A%3C%2FP%3E%0A%3CP%20class%3D%22MsoNormal%22%20style%3D%22margin-bottom%3A%200mm%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fblog.sqlauthority.com%2F2015%2F07%2F07%2Fsql-server-identifying-blocking-chain-using-sql-scripts%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog.sqlauthority.com%2F2015%2F07%2F07%2Fsql-server-identifying-blocking-chain-using-sql-scripts%2F%3C%2FA%3E%3C%2FP%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2368875%22%20slang%3D%22en-US%22%3E%3CP%3ELocks%20are%20held%20in%20the%20database%20to%20ensure%20data%20consistency.%20If%20there%20are%20errors%20due%20to%20lock%20time-out%20or%20performance%20issues%20due%20to%20lock%20waits%2C%20the%20recommendation%20is%20to%20review%20the%20transactions%20that%20are%20involved%20in%20the%20locks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20can%20run%20a%20few%20queries%20to%20gather%20additional%20information%20about%20the%20sessions%20involved%20and%20help%20us%20understand%20why%20the%26nbsp%3Bblock%20is%20happening.%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Co-Authors
Version history
Last update:
‎May 19 2021 09:35 AM
Updated by: