• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

10774: Forwarded Record Count and avg_fragmentation_in_percent

Hi experts;

What is the relationship or difference between the Forwarded Record Count and avg_fragmentation_in_percent. Since in both cases should make REBUILD
0
enrique_aeo
Asked:
enrique_aeo
  • 2
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Forwarded Records usually happens when the table doesn't has a clustered index, so the first option is to create a clustered index and only if isn't possible then you should go for a REBUILD.

avg_fragmentation_in_percent it's the index fragmentation level and depending on the value of this columns the recommended actions are:
If avg_fragmentation_in_percent > 5% and < 30%, then use ALTER INDEX REORGANIZE
If avg_fragmentation_in_percent > 30%, then use ALTER INDEX REBUILD
0
 
enrique_aeoAuthor Commented:
The "Forwarded Record Count" could cause fragmentation? or is an entirely different problem?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, it can cause and that's why a REBUILD can solve the problem but only with a clustered index you'll be sure that the problem won't appear again in a near future.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now