Fragmentation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Fragmentation

I tried rebuilding the index with online and offline mode, even then the avg_fragmentation_in_percent is not getting reduced? Is there any logical reason for it? Can some one explain this? Thanks,
Bala
Refer tohttp://www.sql-server-performance.com/sj_detect_fragmentation.asp &http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11307 to understand further. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Satya, I had read the first URL already. My problem is even after reindexing the avg_fragmentation_in_percent is still 100% for some index id, why is it so? Thanks in Advance.
Bala
Confirm the table structure and corresponding indexes.
What is the fillfactor on this index?
Any clustered index on this table, are you attempting to reindex that as well? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I believe it is also depends on the width of the row because number of rows fit into one page and the left over free space on the page…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

]]>