Link to home
Start Free TrialLog in
Avatar of wasabi3689
wasabi3689Flag for United States of America

asked on

index framentation issue

I have a ms sql 2008 database. It's about 60GB size. Recently, I have index fragmentation very often. I have reorganize and rebuild the index to resolve the problem. I don't know what cause the index fragmentation why so frequency?

My questions:

1. how to identify the root cause why  index fragmentation so frequency?
2. What is solution for that?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of jonnidip
jonnidip
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wasabi3689

ASKER

I think the issue seems too often fragmentation affecting the performance. I have to organize and rebuild the index more frequently in order to resolve this issue.