{"id":887,"date":"2008-01-19T14:55:41","date_gmt":"2008-01-19T13:55:41","guid":{"rendered":"http:\/\/www.glorf.it\/blog\/2008\/01\/19\/sql-server\/replay-markup-language"},"modified":"2008-01-21T12:17:02","modified_gmt":"2008-01-21T11:17:02","slug":"replay-markup-language","status":"publish","type":"post","link":"http:\/\/www.glorf.it\/blog\/2008\/01\/19\/sql-talk\/sql-server\/replay-markup-language","title":{"rendered":"Replay Markup Language"},"content":{"rendered":"<p>Jetzt steht schon der SQl-Server-2008 vor der T&#252;r und dennoch entdecke ich am SQl-Server-2005 immer wieder Dinge von denen ich vorher noch nie geh&#246;rt habe. Zum Beispiel entdeckte ich gerade einen Hotfix f&#252;r die &quot;<a href=\"http:\/\/support.microsoft.com\/default.aspx?scid=kb;en-us;944837&#038;sd=rss&#038;spid=2855\">Replay Markup Language (RML) Utilities for SQL Server<\/a>&quot;.<\/p>\n<p>Was ist denn die &quot;Replay Markup Language&quot;?<\/p>\n<blockquote><p>You can use the RML Utilities for SQL Server to perform the following tasks:<br \/>\n\u2022\tYou can determine the application, the database, the SQL Server login, or the query that is using the most resources.<br \/>\n\u2022\tYou can determine whether the execution plan for a batch is changed when you capture the trace for the batch. Additionally, you can use the RML Utilities for SQL Server to determine how SQL Server performs each of these execution plans.<br \/>\n\u2022\tYou can determine the queries that are running slower than before.<br \/>\nAfter you capture a trace for an instance of SQL Server, you can use the RML Utilities for SQL Server to replay the trace file against another instance of SQL Server. If you also capture the trace during the replay, you can use the RML Utilities for SQL Server to compare the new trace file to the original trace file. You can use this technique to test how SQL Server behaves after you apply changes.<\/p><\/blockquote>\n<p>Naja, ich bin ja lernf&#228;hig. Klingt wenigstens interessant.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jetzt steht schon der SQl-Server-2008 vor der T&#252;r und dennoch entdecke ich am SQl-Server-2005 immer wieder Dinge von denen ich vorher noch nie geh&#246;rt habe. Zum Beispiel entdeckte ich gerade einen Hotfix f&#252;r die &quot;Replay Markup Language (RML) Utilities for SQL Server&quot;. Was ist denn die &quot;Replay Markup Language&quot;? You can use the RML Utilities [&hellip;]<\/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\/887"}],"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=887"}],"version-history":[{"count":0,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/887\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/media?parent=887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/categories?post=887"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/tags?post=887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}