Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to resolve internal fragmentation?

Author  Topic 

bharath.athmarao
Starting Member

3 Posts

Posted - 2014-08-21 : 04:49:56
I am facing internal fragmentation issue. This happens because the
indexed column is been frequently updated.

I resolved this issue by rebuilding and reorganizing index based on the percentage of avg_fragmentation_in_percent.

In production, I have to run at least twice a day which is not advisable.

How can I resolve this issue?

Thanks in advance.

Reagards,
Bharath

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-21 : 05:02:04
are you using a specific fragmentation value to decide rebuild or reorganize?

Javeed Ahmed
Go to Top of Page

bharath.athmarao
Starting Member

3 Posts

Posted - 2014-08-21 : 05:45:35
Javeed,

Yes, based on avg_fragmentation_in_percent I will either rebuild or recognize. If it less than 30% I will go for reorganize and if it is more than 30 percent then I go for rebuild.

Reagards,
Bharath
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-21 : 07:05:59
you can schedule the script to run in non business hours, that should be fine. As you are checking the fragmentation levels and taking the necessary action.

Javeed Ahmed
Go to Top of Page

bharath.athmarao
Starting Member

3 Posts

Posted - 2014-08-25 : 03:03:21
Yes, Is there any other solution other than rebuild or re-organize to resolve internal fragmentation.
Go to Top of Page
   

- Advertisement -