{"id":319,"date":"2021-08-11T10:06:58","date_gmt":"2021-08-11T02:06:58","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=319"},"modified":"2021-08-29T16:00:02","modified_gmt":"2021-08-29T08:00:02","slug":"mariadb%e5%a4%8d%e5%88%b6%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=319","title":{"rendered":"SQL SERVER \u67e5\u8be2\u672a\u63d0\u4ea4\u7684\u4e8b\u52a1"},"content":{"rendered":"<pre><code class=\"language-sql line-numbers\">USE master\nGO\nSET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED\n\nSELECT es.session_id,\n       es.login_name,\n       es.host_name,\n       est.text,\n       cn.last_read,\n       cn.last_write,\n       es.program_name\n  FROM sys.dm_exec_sessions es\n INNER JOIN sys.dm_tran_session_transactions st --\u7cfb\u7edf\u91cc\u8fd8\u5b58\u5728\u7684\u4e8b\u52a1\n         ON es.session_id = st.session_id\n INNER JOIN sys.dm_exec_connections cn\n         ON es.session_id = cn.session_id\n CROSS APPLY sys.dm_exec_sql_text(cn.most_recent_sql_handle) est\n  LEFT JOIN sys.dm_exec_requests er\n         ON st.session_id = er.session_id\n        AND er.session_id IS NULL;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>USE master GO SET TRANSAC&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-319","post","type-post","status-publish","format-standard","hentry","category-sqlserver"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=319"}],"version-history":[{"count":7,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":327,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/319\/revisions\/327"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}