x

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.

more ▼

asked Dec 29, 2011 at 01:56 AM in Default

avatar image

sunithalee143
267 21 23 28

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
more ▼

answered Dec 29, 2011 at 02:10 AM

avatar image

Kev Riley ♦♦
66k 48 63 81

+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

Dec 29, 2011 at 02:20 AM Usman Butt

@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.

Dec 29, 2011 at 02:24 AM Usman Butt

Haha no! I just have a memory for common questions, that I answered. A couple of clicks and I found the right one....

Dec 29, 2011 at 02:29 AM Kev Riley ♦♦

Got that :) Moreover, It could also be quick by following the correct tags as well :) I have just tagged this one as well.

Dec 29, 2011 at 02:31 AM Usman Butt

@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!

Dec 29, 2011 at 02:46 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Dec 29, 2011 at 01:58 AM

avatar image

Sharma
1.4k 90 93 96

yes the table is having low volume then how to proceed can u please guide

Dec 29, 2011 at 02:22 AM sunithalee143

Follow the links in the other answer I have linked to, and these MSDN articles will explain why the fragmentation cannot be reduced.

Dec 29, 2011 at 02:25 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2027
x99
x25

asked: Dec 29, 2011 at 01:56 AM

Seen: 1288 times

Last Updated: Dec 29, 2011 at 02:27 AM

Copyright 2017 Redgate Software. Privacy Policy