Groups > comp.databases.ms-sqlserver > #311

Re: SQL Server 2008 R2 - Reorganize Index taking too long

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Server 2008 R2 - Reorganize Index taking too long
Date	2011-05-09 23:59 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9EE0F4071D7E0Yazorman@127.0.0.1> (permalink)
References	<8c0611f4-0dd5-42b5-babf-61bc3610f30d@x1g2000yqb.googlegroups.com> <Xns9EDD819F48961Yazorman@127.0.0.1> <pib8s6husomscer2hid78mln5hhvhhr1al@4ax.com> <Xns9EDDF25D9A4A8Yazorman@127.0.0.1> <a525424b-07ec-43f0-b864-d29ef65a88b4@28g2000yqu.googlegroups.com>

Show all headers | View raw

SGoncalves (goncalves.sergiom@gmail.com) writes:
> I've been checking fragmentation levels in the production database,
> and I've encountered some curious (or not).
> When I select the sys.dm_db_index_physical_stats I have many indexes
> with 99% avg_fragmentation_in_percent, but when I go through the GUI
> into the same indexes and check the fragmentation it show 0,01%.
 
Not sure what you see, but beware that if you run with DETAILED mode,
you will also get the intermediate levels in the index, and they are often 
quite fragmented. On the other hand that is no cause for alarm.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQL Server 2008 R2 - Reorganize Index taking too long SGoncalves <goncalves.sergiom@gmail.com> - 2011-05-06 02:09 -0700
  Re: SQL Server 2008 R2 - Reorganize Index taking too long Erland Sommarskog <esquel@sommarskog.se> - 2011-05-06 10:44 +0000
    Re: SQL Server 2008 R2 - Reorganize Index taking too long SGoncalves <goncalves.sergiom@gmail.com> - 2011-05-06 06:59 -0700
    Re: SQL Server 2008 R2 - Reorganize Index taking too long Gene Wirchenko <genew@ocis.net> - 2011-05-06 10:23 -0700
      Re: SQL Server 2008 R2 - Reorganize Index taking too long Erland Sommarskog <esquel@sommarskog.se> - 2011-05-06 23:49 +0200
        Re: SQL Server 2008 R2 - Reorganize Index taking too long SGoncalves <goncalves.sergiom@gmail.com> - 2011-05-09 03:00 -0700
          Re: SQL Server 2008 R2 - Reorganize Index taking too long Erland Sommarskog <esquel@sommarskog.se> - 2011-05-09 23:59 +0200
            Re: SQL Server 2008 R2 - Reorganize Index taking too long SGoncalves <goncalves.sergiom@gmail.com> - 2011-05-10 03:44 -0700
              Re: SQL Server 2008 R2 - Reorganize Index taking too long Henk van den Berg <hvandenberg@xs4all.nl> - 2011-05-10 12:51 +0200
                Re: SQL Server 2008 R2 - Reorganize Index taking too long Henk van den Berg <hvandenberg@xs4all.nl> - 2011-05-10 12:53 +0200
              Re: SQL Server 2008 R2 - Reorganize Index taking too long Erland Sommarskog <esquel@sommarskog.se> - 2011-05-10 23:36 +0200
                Re: SQL Server 2008 R2 - Reorganize Index taking too long SGoncalves <goncalves.sergiom@gmail.com> - 2011-05-11 03:22 -0700

csiph-web