{"id":580,"date":"2016-10-04T03:47:41","date_gmt":"2016-10-04T03:47:41","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=580"},"modified":"2016-10-05T03:20:49","modified_gmt":"2016-10-05T03:20:49","slug":"backup","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=580","title":{"rendered":"Sessions"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nLong running session (only incomplete)<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSELECT R.session_id, \r\nR.percent_complete, \r\nR.total_elapsed_time\/1000 AS elapsed_secs, \r\nR.wait_type,\r\nR.wait_time,\r\nR.last_wait_type,\r\nDATEADD(s,100\/((R.percent_complete)\/ (R.total_elapsed_time\/1000)), R.start_time) estim_completion_time,\r\nST.text, \r\nSUBSTRING(ST.text, R.statement_start_offset \/ 2, \r\n (\r\n CASE WHEN R.statement_end_offset = -1 THEN DATALENGTH(ST.text)\r\n ELSE R.statement_end_offset\r\n END - R.statement_start_offset \r\n ) \/ 2\r\n) AS statement_executing\r\nFROM sys.dm_exec_requests R\r\nCROSS APPLY sys.dm_exec_sql_text(R.sql_handle) ST\r\nWHERE R.percent_complete > 0 and\r\nR.session_id <> @@spid -- not the current session\r\nOPTION(RECOMPILE);\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSELECT R.session_id,<br \/>\nR.percent_complete,<br \/>\nR.total_elapsed_time\/1000 AS elapsed_secs,<br \/>\nR.wait_type,<br \/>\nR.wait_time,<br \/>\nR.last_wait_type,<br \/>\nDATEADD(s,100\/((R.percent_complete)\/ (R.total_elapsed_time\/1000)), R.start_time) estim_completion_time,<br \/>\nST.text,<br \/>\nSUBSTRING(ST.text, R.statement_start_offset \/ 2,<br \/>\n (<br \/>\n CASE WHEN R.statement_end_offset = -1 THEN DATALENGTH(ST.text)<br \/>\n ELSE R.statement_end_offset<br \/>\n END - R.statement_start_offset<br \/>\n ) \/ 2<br \/>\n) AS statement_executing<br \/>\nFROM sys.dm_exec_requests R<br \/>\nCROSS APPLY sys.dm_exec_sql_text(R.sql_handle) ST<br \/>\nWHERE R.percent_complete > 0 and<br \/>\nR.session_id <> @@spid -- not the current session<br \/>\nOPTION(RECOMPILE);<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nLong running session (including completed)<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSELECT R.session_id, \r\nR.percent_complete, \r\nR.total_elapsed_time\/1000 AS elapsed_secs, \r\nR.wait_type,\r\nR.wait_time,\r\nR.last_wait_type,\r\nST.text, \r\nSUBSTRING(ST.text, R.statement_start_offset \/ 2, \r\n (\r\n CASE WHEN R.statement_end_offset = -1 THEN DATALENGTH(ST.text)\r\n ELSE R.statement_end_offset\r\n END - R.statement_start_offset \r\n ) \/ 2\r\n) AS statement_executing\r\nFROM sys.dm_exec_requests R\r\nCROSS APPLY sys.dm_exec_sql_text(R.sql_handle) ST\r\nWHERE \r\nR.session_id <> @@spid -- not the current session\r\nOPTION(RECOMPILE);\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSELECT R.session_id,<br \/>\nR.percent_complete,<br \/>\nR.total_elapsed_time\/1000 AS elapsed_secs,<br \/>\nR.wait_type,<br \/>\nR.wait_time,<br \/>\nR.last_wait_type,<br \/>\nST.text,<br \/>\nSUBSTRING(ST.text, R.statement_start_offset \/ 2,<br \/>\n (<br \/>\n CASE WHEN R.statement_end_offset = -1 THEN DATALENGTH(ST.text)<br \/>\n ELSE R.statement_end_offset<br \/>\n END - R.statement_start_offset<br \/>\n ) \/ 2<br \/>\n) AS statement_executing<br \/>\nFROM sys.dm_exec_requests R<br \/>\nCROSS APPLY sys.dm_exec_sql_text(R.sql_handle) ST<br \/>\nWHERE<br \/>\nR.session_id <> @@spid -- not the current session<br \/>\nOPTION(RECOMPILE);<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Long running session (only incomplete) SELECT R.session_id, R.percent_complete, R.total_elapsed_time\/1000 AS elapsed_secs, R.wait_type, R.wait_time, R.last_wait_type, DATEADD(s,100\/((R.percent_complete)\/ (R.total_elapsed_time\/1000)), R.start_time) estim_completion_time, ST.text, SUBSTRING(ST.text, R.statement_start_offset \/ 2, ( CASE WHEN R.statement_end_offset = -1 THEN DATALENGTH(ST.text) ELSE R.statement_end_offset END &#8211; R.statement_start_offset ) \/ 2 ) AS statement_executing FROM sys.dm_exec_requests R CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) ST WHERE R.percent_complete > 0 and R.session_id [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":578,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-580","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-9m","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=580"}],"version-history":[{"count":5,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/580\/revisions"}],"predecessor-version":[{"id":623,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/580\/revisions\/623"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/578"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}