Accuracy of Results and sp_helpartition

The values reported in the “pages” column may differ from the actual values. To determine whether the count is inaccurate, run sp_statistics and sp_helpartition to compare the data page count. The count provided by sp_statistics is always accurate.

If the page count reported by sp_statistics differs from the sum of the partition pages reported by sp_helpartition by more then 5 percent, run one of these commands to update the partition statistics:
  • dbcc checkdb

  • dbcc checktable

  • update all statistics

  • update table statistics

Then, rerun sp_helpartition for an accurate report.

Related reference