Search code examples
sqlsql-serverindexingfragmentationrebuild

Interpreting "Total Fragmentation" column when rebuilding an index in SQL

I can't find it now but somewhere in the comments of a post in stack overflow someone said the .85 is 85% when checking the Total Fragmentation column you see when right clicking on an index in SSMS and hitting Rebuild. But I can't find anything else that says that.

So I want to know, is .85 == 85% and 1.25 == 125% fragmentation?

Or is .85 == 0.85% and 1.25 == 1.25% fragmentation?

I'm sure this is a dumb question as most everything else states the latter in an implied way, but I just wanted to double check.

Solution

  • Not sure why people avoid answering the questions directly, but your answer is, 0.85 in EM is just like it says, 0.85%