July 17, 2007 at 7:45 am
I have seen this in situations where there are VERY few (< 100) rows in a table, and I also think it had to be a clustered index for that situation to occur.
The Fill Factor will also impact this. If you have a number different than 0 or 100, this can increase the amount of fragmentation in smaller tables. DON'T change a NON-DEFAULT fill factor to eliminate fragmentation. It is NOT a problem to have some minor fragmentation.
Lastly, if you rebuild an index and it's fragmentation doesn't change. It's as good as it is going to get.
Basically there are some indexes that will have a degree of fragmentation no matter what.
July 18, 2007 at 7:07 am
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=360&messageid=355979#bm356969
the online will only work if you have Enterprise Edition
July 30, 2007 at 1:08 pm
I'm a big fan of a index manager solution. I have 3 production SQL Server boxes that my index manager runs. Each production box is slightly different. None the less, after I've gone ahead and implemented the manager SQL Server database problems/issues have been minimized and have stable. RHWI has 3 major online sites some of which sees over 2 million hits daily.
The latest change I made to one of the production boxes is to run the analysis on another box. We are performing logshipping to a second sql server box. Log shipping takes place every 15 minutes and runs over an expanded prime-time window. The analysis phase now runs on the copy and I report back the work that needs to be done. By doing this I've cut my process down by over 50%. The analysis phase takes almost as long as to determine what work has to be processed. By offloading this part of the process I've managed to reduce SQL Server congestion. This analysis process takes almost as long as the rebuilding/reindexing the earmarked indexes.
Any questions please feel free to contact me.
Kurt - DBA
RHWI, Inc.
Poughkeepsie, NY
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman
July 30, 2007 at 1:12 pm
By the way I have a 2000 & 2005 solution. It's just the right thing to do!
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman
February 9, 2009 at 10:00 am
Hello,
Can you please provide additional details about the Index Manager. I am trying to find the most effecient method to mnage indexes on our production server which is running 2005
Thanks
Shri
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply