Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index fragmentation Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 1:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:23 PM
Points: 98, Visits: 275
Dear Experts

I have made a tracing file, then run tuning advisor. The recommendation shows a lot of indexes. I looked at the fragmentation for some indexs and I found it 50%. I made rebuild.

I OPEND THE FRAGMENTATION AGAIN AND FOUND IT STILL 50%

any idea why it remains as it is after rebuilding index.

Thanks lot
Post #1418779
Posted Tuesday, February 12, 2013 1:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
Let me guess, tiny table, 2 or 4 pages in size.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1418789
Posted Tuesday, February 12, 2013 8:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, December 14, 2014 11:59 PM
Points: 333, Visits: 555
The most important thing here is not the amount a fragmentation but rather the ratio of fragmentation to pages. If you have 4 pages with 50% fragmentation I would not worry about there being a problem. If I have 1000 pages with 50% fragmentation then something needs to be done!

This is a situation whereby understanding the collective information presented on the screen is a great deal more important than seeing a single number and thinking the world is going to end!
Post #1418990
Posted Tuesday, February 12, 2013 2:04 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:23 PM
Points: 98, Visits: 275

Thank you
Post #1419181
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse