http://blogs.msdn.com/b/timchapman/archive/2012/09/28/index-rebuild-vs-reorganize-the-transaction-log-edition.aspxRecently a friend and fellow PFE Dave Levy ( Twitter / Blog ) and I were discussing a question someone posted in a forum. The question was in regards to database mirroring latency when a reorganization occurs. Dave mentioned that he has seen in the pasten-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/timchapman/archive/2012/09/28/index-rebuild-vs-reorganize-the-transaction-log-edition.aspx#10371950Tue, 27 Nov 2012 06:52:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:10371950patrick<p>For &nbsp;defragmentation of sql server we can also use a specific tool this will save our time also ..this will give a complete report for your server performance related activitis where we can monitor all transaction log also </p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10371950" width="1" height="1">http://blogs.msdn.com/b/timchapman/archive/2012/09/28/index-rebuild-vs-reorganize-the-transaction-log-edition.aspx#10356234Fri, 05 Oct 2012 04:30:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:10356234ram<p>We are seeing otherwise. Reorganize generates large amount of logs on a table that is 5% fragmented and 100 GB in size.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10356234" width="1" height="1">http://blogs.msdn.com/b/timchapman/archive/2012/09/28/index-rebuild-vs-reorganize-the-transaction-log-edition.aspx#10354229Fri, 28 Sep 2012 17:24:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:10354229TimChapman<p>Thanks Paul, and I completely agree. &nbsp;In this post I was going for a completely fragmented index, but I&#39;ll add some info regarding what you said. &nbsp;I don&#39;t want people to make decisions based just on the log generation rate.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10354229" width="1" height="1">http://blogs.msdn.com/b/timchapman/archive/2012/09/28/index-rebuild-vs-reorganize-the-transaction-log-edition.aspx#10354224Fri, 28 Sep 2012 17:12:16 GMT91d46819-8472-40ad-a661-2c78acb4018c:10354224Paul Randal<p>What was the fragmentation level of the index before each operation? Remember that a reorganize is not efficient for a heavily fragmented index - by design. You need to consider the fragmentation because the rebuild will *always* generate a new index, with all those log records, but for a low-fragmented index, the reorganize will hardly generate any.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10354224" width="1" height="1">