{"id":326,"date":"2023-08-08T16:46:46","date_gmt":"2023-08-08T13:46:46","guid":{"rendered":"https:\/\/kb.astrocroc.com\/?p=326"},"modified":"2023-09-01T21:30:50","modified_gmt":"2023-09-01T18:30:50","slug":"%d0%bf%d1%80%d0%be%d1%81%d0%bc%d0%be%d1%82%d1%80-%d0%b7%d0%b0%d0%b2%d0%b8%d1%81%d1%88%d0%b8%d1%85-%d0%b7%d0%b0%d0%bf%d1%80%d0%be%d1%81%d0%be%d0%b2-mssql-%d0%b2-%d1%82%d0%be%d0%bc-%d1%87%d0%b8%d1%81","status":"publish","type":"post","link":"https:\/\/kb.astrocroc.com\/?p=326","title":{"rendered":"\u041f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0437\u0430\u0432\u0438\u0441\u0448\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 MSSQL \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0441 \u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u043a\u0430\u043c\u0438"},"content":{"rendered":"\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\" data-line=\"\">SELECT\nr.start_time,\n       p.spid\n       , p.blocked\n       , p.hostname\n       , p.program_name\n       , p.nt_username\n       , r.command\n       , r.status\n       , CASE WHEN statement_start_offset = 0 THEN t.text\n             ELSE (SELECT TOP 1 SUBSTRING(t.text,statement_start_offset \/ 2+1 , \n             ((CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(nvarchar(max),t.text)) * 2) \n     ELSE statement_end_offset END) - statement_start_offset) \/ 2+1)) \n       END AS sql_statement\n       , t.text raw_text\n       , r.blocking_session_id\n       , r.wait_time\n       , r.wait_type\n       , r.wait_resource\n       , r.last_wait_type\n       ,r.logical_reads\n       ,qp.query_plan\n,r.sql_handle \nFROM sys.dm_exec_requests r\nINNER JOIN sys.sysprocesses p\n       ON p.spid = r.session_id\nCROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS t\nCROSS APPLY sys.dm_exec_query_plan(r.plan_handle) qp\nORDER BY\np.spid\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[54],"class_list":["post-326","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mssql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=326"}],"version-history":[{"count":1,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}