Исходный код вики Поиск блокировок
Версия 3.1 от Alexandr Fokin на 2020/10/29 19:01
Последние авторы
| author | version | line-number | content |
|---|---|---|---|
| 1 | |||
| 2 | ПОЛУЧЕНИЕ ИНФОРМАЦИИ О ТЕКУЩИХ ИСПОЛНЯЕМЫХ ЗАПРОСАХ MS SQL SERVER | ||
| 3 | https://ausevich.ru/subd/poluchenie-informatsii-o-tekushchikh-ispolnyaemykh-zaprosakh/ | ||
| 4 | |||
| 5 | {{code language="sql"}} | ||
| 6 | |||
| 7 | SELECT | ||
| 8 | DB_NAME(er.database_id) AS DB_Name, | ||
| 9 | er.start_time, | ||
| 10 | er.session_id, | ||
| 11 | er.status, | ||
| 12 | er.command, | ||
| 13 | - - performance: er.reads + er.writes AS IO, | ||
| 14 | er.logical_reads, | ||
| 15 | er.cpu_time, | ||
| 16 | er.total_elapsed_time, | ||
| 17 | - - waits: er.blocking_session_id, | ||
| 18 | er.wait_type, | ||
| 19 | er.wait_time, | ||
| 20 | er.wait_resource, | ||
| 21 | - - query: qt.text, | ||
| 22 | qp.query_plan | ||
| 23 | FROM | ||
| 24 | sys.dm_exec_requests as er | ||
| 25 | CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) qt | ||
| 26 | CROSS APPLY sys.dm_exec_query_plan(er.plan_handle) qp | ||
| 27 | WHERE | ||
| 28 | er.database_id = DB_ID('MyBase') | ||
| 29 | |||
| 30 | {{/code}} |