Rebuild Index Stats - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Rebuild Index Stats

Author

Topic

Kwisatz
Starting Member

14 Posts

Posted - 2009-08-28 : 10:28:34

Hi all prior to an index rebuild I had the following stats

avg_fragmentation% 53.70705244
fragment_count 1297
avg_fragment_size_in_pages 1.705474171
page_count 12212

After I ran the rebuild I got the following stats:

avg_fragmentation% 93.10728182
fragment_count 1689
avg_fragment_size_in_pages 1.065127294
page_count 1799

I am confused with this as the fragmentation for this index seems to have increased after the rebuild, can anyone advise on what has happened?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-28 : 15:47:32

How many rows are there in the table?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."