Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Unanswered: sp_spaceused or used_pgs(...)

    When indentifying the space used by a specify table, there seems to be two approaches available, use sp_spaceused or use used_pgs(...).
    I'm not clear about the difference of these two, and for estimating table space for cache binding, which one provides more accurate result please?

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    I reckon it is because used_pgs does not handle table without OAM pages like syslogs.

    which is why you need to use sp_spaceused

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts