February 23, 2011 at 7:06 am
I do reindexing as weekly activity in all my servers but still i get huge fragmentation????? wat can be the reason for that???? wat should i do to get rid of that?????
February 23, 2011 at 7:13 am
There could be numerous reasons. Do you or someone use large INSERT statements?
A great article by Randy Dyess touches on index fragmentation - http://www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 23, 2011 at 7:20 am
Some examples of tables, data and usage would be useful. How many pages are in these tables (less than 1000 wont re-index as you expect)?
February 23, 2011 at 8:14 am
When you say reindex, is that an index defrag or an index rebuild? You'll get less de-fragmentation from the defrag than you do from the rebuild. But also, as was noted, smaller sets of pages (less than 1000 pages, but certainly below 100) may not defrag. Less than 8 pages, one extent, won't defrag at all.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply