Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
+-----------------------------+------------+------------+-------------------------+-----------+---------+--------------------------------------------------------------------------------------------+------------------------+----------------------+--------------------------------------------------------------------------------------------+-------------+---------+--------------------------------------+---------------------+-----------+-----------+----------------+-----------------------------------------+------------------------+----------------------+----------------+--------------+------------------+---------------------------+----------+--------------------+--------------+--------------------+-------+--------+---------------+-----------+------------+-------------+------------+-------------------+------------+-------------------+---------------+---------------+--------------+------------+-------------------------+-----------------------------+--------------+-------------------+-----------+------------+------------+----------------------+------------------------+----------+--------------------+--------------------+----------------------+----------------------+-------------------------+-----------+-----------------------+-----------------+----------------+-----------------------+------------------------------------------------------------+-----------------+-----------+--------------+--------------+----------------------+-------------+-------------------------+-------------------------+-----------------+------------------------------------------------------------+---------------------+-----------------------+-------------------------+---------------------+----------------------------+
| CaptureTime | session_id | request_id | start_time | status | command | sql_handle | statement_start_offset | statement_end_offset | plan_handle | database_id | user_id | connection_id | blocking_session_id | wait_type | wait_time | last_wait_type | wait_resource | open_transaction_count | open_resultset_count | transaction_id | context_info | percent_complete | estimated_completion_time | cpu_time | total_elapsed_time | scheduler_id | task_address | reads | writes | logical_reads | text_size | language | date_format | date_first | quoted_identifier | arithabort | ansi_null_dflt_on | ansi_defaults | ansi_warnings | ansi_padding | ansi_nulls | concat_null_yields_null | transaction_isolation_level | lock_timeout | deadlock_priority | row_count | prev_error | nest_level | granted_query_memory | executing_managed_code | group_id | query_hash | query_plan_hash | statement_sql_handle | statement_context_id | login_time | host_name | program_name | host_process_id | client_version | client_interface_name | security_id | login_name | nt_domain | nt_user_name | memory_usage | total_scheduled_time | endpoint_id | last_request_start_time | last_request_end_time | is_user_process | original_security_id | original_login_name | last_successful_logon | last_unsuccessful_logon | unsuccessful_logons | authenticating_database_id |
+-----------------------------+------------+------------+-------------------------+-----------+---------+--------------------------------------------------------------------------------------------+------------------------+----------------------+--------------------------------------------------------------------------------------------+-------------+---------+--------------------------------------+---------------------+-----------+-----------+----------------+-----------------------------------------+------------------------+----------------------+----------------+--------------+------------------+---------------------------+----------+--------------------+--------------+--------------------+-------+--------+---------------+-----------+------------+-------------+------------+-------------------+------------+-------------------+---------------+---------------+--------------+------------+-------------------------+-----------------------------+--------------+-------------------+-----------+------------+------------+----------------------+------------------------+----------+--------------------+--------------------+----------------------+----------------------+-------------------------+-----------+-----------------------+-----------------+----------------+-----------------------+------------------------------------------------------------+-----------------+-----------+--------------+--------------+----------------------+-------------+-------------------------+-------------------------+-----------------+------------------------------------------------------------+---------------------+-----------------------+-------------------------+---------------------+----------------------------+
| 2017-04-13 07:39:21.0395400 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 3382 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 3382 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:39:30.9611614 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 13299 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 13299 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:39:40.1171760 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 22462 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 22462 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:39:50.1637943 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 32500 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 32500 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:00.2729116 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 42612 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 42612 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:10.3507786 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 52694 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 52694 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:20.4442695 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 62795 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 62795 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:30.5846352 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 72931 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 72931 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:40.6000039 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 82944 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 82944 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
| 2017-04-13 07:40:50.6622466 | 106 | 0 | 2017-04-13 07:39:17.657 | suspended | UPDATE | 0x0200000076A6A92AB1256AF09321B056AB243F187342F9960000000000000000000000000000000000000000 | 72 | 256 | 0x0600050076A6A92AC073053E2100000001000000000000000000000000000000000000000000000000000000 | 5 | 1 | 45BDB46D-0326-423A-BC98-AA6FC7651A87 | 105 | LCK_M_U | 93011 | LCK_M_U | KEY: 5:72057597585719296 (d2d87c26d920) | 2 | 1 | 4436575948 | 0x | 0 | 0 | 0 | 93011 | 2 | 0x0000000D06909C28 | 0 | 0 | 6 | -1 | us_english | mdy | 7 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | -1 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0xA3C5FED208AD6D25 | 0xC6D4A88698A910B6 | NULL | NULL | 2017-04-13 06:00:10.127 | ******** | Microsoft Dynamics AX | 11800 | 7 | ODBC | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | **** | ********** | 12 | 12848 | 4 | 2017-04-13 07:39:17.657 | 2017-04-13 07:39:17.657 | 1 | 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 | *************** | NULL | NULL | NULL | 1 |
+-----------------------------+------------+------------+-------------------------+-----------+---------+--------------------------------------------------------------------------------------------+------------------------+----------------------+--------------------------------------------------------------------------------------------+-------------+---------+--------------------------------------+---------------------+-----------+-----------+----------------+-----------------------------------------+------------------------+----------------------+----------------+--------------+------------------+---------------------------+----------+--------------------+--------------+--------------------+-------+--------+---------------+-----------+------------+-------------+------------+-------------------+------------+-------------------+---------------+---------------+--------------+------------+-------------------------+-----------------------------+--------------+-------------------+-----------+------------+------------+----------------------+------------------------+----------+--------------------+--------------------+----------------------+----------------------+-------------------------+-----------+-----------------------+-----------------+----------------+-----------------------+------------------------------------------------------------+-----------------+-----------+--------------+--------------+----------------------+-------------+-------------------------+-------------------------+-----------------+------------------------------------------------------------+---------------------+-----------------------+-------------------------+---------------------+----------------------------+
+-----------------------------+---------------+------------------+----------------------+----------------------+-------------------------------+-------------------------+--------------+--------------+----------------+-------------------------+------------------+--------------------+-------------------------+--------------------+--------------------+------------------+--------------------------------------+----------------------------+--------------------+
| CaptureTime | resource_type | resource_subtype | resource_database_id | resource_description | resource_associated_entity_id | resource_lock_partition | request_mode | request_type | request_status | request_reference_count | request_lifetime | request_session_id | request_exec_context_id | request_request_id | request_owner_type | request_owner_id | request_owner_guid | request_owner_lockspace_id | lock_owner_address |
+-----------------------------+---------------+------------------+----------------------+----------------------+-------------------------------+-------------------------+--------------+--------------+----------------+-------------------------+------------------+--------------------+-------------------------+--------------------+--------------------+------------------+--------------------------------------+----------------------------+--------------------+
| 2017-04-13 07:39:21.0551647 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:40.6000039 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:39:30.9611614 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:39:40.1171760 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:39:50.1637943 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:20.4598934 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:00.2729116 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:10.3507786 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:30.5846352 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
| 2017-04-13 07:40:50.6622466 | KEY | | 5 | (d2d87c26d920) | 72057597585719296 | 0 | U | LOCK | WAIT | 1 | 0 | 106 | 0 | 0 | TRANSACTION | 4436575948 | 00000000-0000-0000-0000-000000000000 | 0x0000000FC0575F70:1:1 | 0x0000000BF7C59FC0 |
+-----------------------------+---------------+------------------+----------------------+----------------------+-------------------------------+-------------------------+--------------+--------------+----------------+-------------------------+------------------+--------------------+-------------------------+--------------------+--------------------+------------------+--------------------------------------+----------------------------+--------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.