Inaccurate Space Metadata Possible Causes

  • cjb110

    SSC Enthusiast

    Points: 140

    We've got a database that has reported 'In-row data USED page count for object' and 'In-row data RSVD page count for object' for a couple of objects.  The fix suggested has been applied successfully.

    So far everything I've found says this is an artifact from 2000 to 2005+ conversion, and this database was converted from 2000 to 2008R2, but that was years ago.

    So is the conversion still the most likely cause of this corruption?

    Or what other parts of the system should we be looking at?

  • Site Owners

    SSC Guru

    Points: 80380

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • crow1969

    SSCrazy

    Points: 2909

    In some of the earlier iterations of column store indexes, the space used was reported a bit low, if I recall.  Could that be contributing here?

  • cjb110

    SSC Enthusiast

    Points: 140

    Nope, don't think so, as wasn't column store indexes introduced in the 2012 version?  We're on 2008R2.

    But something similar maybe?  The objects that were effected were tables used in a ETL type process, so each month-end they are emptied and refilled, then just read from to populate other tables.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply