Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fragmented indexes
Message
 
 
To
16/03/2011 12:34:53
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01503886
Message ID:
01503888
Views:
32
>In databases created by Sharepoint I am unable to effectively keep indexes from significant fragmentation. Index rebuilding is done every night, but there are still many with over 80% fragmentation. This is being done as part of the maintenance plan each night. Is there something I might do that would work better?

What if the fill factor for your indexes and what kind of indexes they are? Also, how big are your tables?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform