Skip to main content
Database Administrators

Return to Question

deleted 77 characters in body; edited tags
Source Link
Colin 't Hart
Colin 't Hart
  • 9.4k
  • 15
  • 36
  • 44

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  • 100

  • 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  • 100

  • 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  • 100

  • 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

tag and formatting
Source Link
Shanky
Shanky
  • 19.1k
  • 4
  • 36
  • 58

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_statssys.dm_db_index_physical_stats contains column avg_page_space_used_in_percentcolumn avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:For example:

I have index idx_HeaderInfoidx_HeaderInfo

I create the index with a fill factor of 80%80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  1. 100
  2. 80

  • 100

  • 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  1. 100
  2. 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  • 100

  • 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance

Source Link
Hpk
Hpk
  • 304
  • 2
  • 12

avg_page_space_used_in_percent and fill factor

Trying to find an answer to this one but struggling.

sys.dm_db_index_physical_stats contains column avg_page_space_used_in_percent.

How does this fit in with the fill factor of an index?

For example:

I have index idx_HeaderInfo

I create the index with a fill factor of 80%.

If I then immediately look at avg_page_space_used_in_percent do I see:

  1. 100
  2. 80

I ask because I need a way of rebuilding or reorganising based on internal fragmentation rather than external and I don't want to create logic to rebuild/reorg if a avg_page_space_used_in_percent < 75 if the fill factor in the first place is 70 for instance.

Thanks in advance