home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,313 of 19,505   
   Henk van den Berg to SGoncalves   
   Re: SQL Server 2008 R2 - Reorganize Inde   
   10 May 11 12:51:45   
   
   0d6c1fb1   
   From: hvandenberg@xs4all.nl   
      
   SGoncalves schreef op 10-05-2011 12:44:   
   > On May 9, 10:59 pm, Erland Sommarskog  wrote:   
   >> SGoncalves (goncalves.serg...@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, esq...@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   
   >   
   > How can I check the DETAILED mode?   
   >   
   > Thanks in advance.   
      
   http://msdn.microsoft.com/en-us/library/ms188917.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca