asked
defragmentation issue
Hello all, i am trying to reduce the fragmentation percentage.i used sys.dm_db_index_physical_stats to see the fragmentation percentage then i got 90% fragmentation then i tried to reduce the fragmentation percentage by using < Alter index all on production.product rebuild > with this the command executed successfully but when i checked the percentage again it shown 90% it was not reduced i am confused with this please help how to proceed in this case.
Please check your table data some time if table data volume is low then it would not decrease the fragmentation but it will not decrease your performance.
Follow the links in the other answer I have linked to, and these MSDN articles will explain why the fragmentation cannot be reduced.
yes the table is having low volume then how to proceed can u please guide
Similar discussion here :
Haha no! I just have a memory for common questions, that I answered. A couple of clicks and I found the right one....
@Usman improving the search (and indeed improving the whole site) is something that is being worked on. We have discussed the ability to have a much better, advanced search, including searching questions/answers by user. Hang on in there, we'll get there!
+1. In addition I think this link should follow after visiting BOL/MSDN.
http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/28/fragmentation-revisited.aspx
@Kev, have you saved some reference for that? I am asking because it was kind of very quick, and the question is not marked favorite as well.
Got that :) Moreover, It could also be quick by following the correct tags as well :) I have just tagged this one as well.
