{"id":801,"date":"2007-11-14T21:35:27","date_gmt":"2007-11-14T20:35:27","guid":{"rendered":"http:\/\/www.glorf.it\/blog\/2007\/11\/14\/sql-server\/profiler-traces-in-einer-tabelle-auswerten"},"modified":"2007-11-14T21:35:27","modified_gmt":"2007-11-14T20:35:27","slug":"profiler-traces-in-einer-tabelle-auswerten","status":"publish","type":"post","link":"http:\/\/www.glorf.it\/blog\/2007\/11\/14\/sql-talk\/sql-server\/profiler-traces-in-einer-tabelle-auswerten","title":{"rendered":"Profiler-Traces in einer Tabelle auswerten"},"content":{"rendered":"<p>Im SQL-Team-Blog von Mladen Prajdi&#196;? wird ein guter Tipp ver&#246;ffentlicht, wie man in einer Tabelle gespeicherte Profiler-Traces etwas lesbarer machen kann: Durch einen Join auf die View sys.trace_events.<\/p>\n<p>Hier stehts: &quot;<a href=\"http:\/\/weblogs.sqlteam.com\/mladenp\/archive\/2007\/11\/09\/Map-SQL-Server-Profiler-EventClass-ID-to-its-name-in.aspx\">Map SQL Server Profiler EventClass ID to its name in a saved trace table<\/a>&quot;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Im SQL-Team-Blog von Mladen Prajdi&#196;? wird ein guter Tipp ver&#246;ffentlicht, wie man in einer Tabelle gespeicherte Profiler-Traces etwas lesbarer machen kann: Durch einen Join auf die View sys.trace_events. Hier stehts: &quot;Map SQL Server Profiler EventClass ID to its name in a saved trace table&quot;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[],"_links":{"self":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/801"}],"collection":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/comments?post=801"}],"version-history":[{"count":0,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/801\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/media?parent=801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/categories?post=801"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/tags?post=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}