question

sunithalee143 avatar image
sunithalee143 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.
sql-server-2005indexesfragmentation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sharma avatar image
Sharma answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Follow the links in the other answer I have linked to, and these MSDN articles will explain why the fragmentation cannot be reduced.
1 Like 1 ·
sunithalee143 avatar image sunithalee143 commented ·
yes the table is having low volume then how to proceed can u please guide
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
Similar discussion here :
7 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Haha no! I just have a memory for common questions, that I answered. A couple of clicks and I found the right one....
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
@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 Like 1 ·
Usman Butt avatar image Usman Butt commented ·
+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
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
@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.
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
Got that :) Moreover, It could also be quick by following the correct tags as well :) I have just tagged this one as well.
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.