{"id":96,"date":"2012-11-30T15:44:58","date_gmt":"2012-11-30T13:44:58","guid":{"rendered":"http:\/\/neuronetix.de\/?p=96"},"modified":"2019-02-25T20:02:04","modified_gmt":"2019-02-25T18:02:04","slug":"sql-server-prozesse-per-t-sql-abfragen","status":"publish","type":"post","link":"https:\/\/neuronetix.de\/?p=96","title":{"rendered":"SQL Server Prozesse per T-SQL abfragen"},"content":{"rendered":"<p>Beispielsweise per sqlcmd, oder auch im Management Studio lassen sich laufende Prozesse mit folgender Abfrage anzeigen:<\/p>\n<pre>select session_id, status, command from sys.dm_exec_requests<\/pre>\n<pre>go<\/pre>\n<p>Mehr zu sys.dm_exec_requests und deren Spalten hier:\u00a0<a href=\"http:\/\/msdn.microsoft.com\/de-de\/library\/ms177648(v=sql.90).aspx\">http:\/\/msdn.microsoft.com\/de-de\/library\/ms177648(v=sql.90).aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Beispielsweise per sqlcmd, oder auch im Management Studio lassen sich laufende Prozesse mit folgender Abfrage anzeigen: select session_id, status, command from sys.dm_exec_requests go Mehr zu sys.dm_exec_requests und deren Spalten hier:\u00a0http:\/\/msdn.microsoft.com\/de-de\/library\/ms177648(v=sql.90).aspx<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[51,35,52,34,53],"_links":{"self":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/96"}],"collection":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=96"}],"version-history":[{"count":2,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":396,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/96\/revisions\/396"}],"wp:attachment":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}