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.
| Author |
Topic |
|
bharath.athmarao
Starting Member
3 Posts |
 Posted - 2014-08-21 : 04:49:56
|
| I am facing internal fragmentation issue. This happens because theindexed 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 |
 |
|
|
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 |
|
|
|
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 |
|
|
|
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. |
|
|
|
|
|
|
How to resolve internal fragmentation?