BW on ASE 16.0: table size in DBACOCKPIT?

[Former Member]

Hi all,

we recently migrated our SAP BW database from MS SQL Server to ASE 16.0.

Now I want to check the table size of a table in DBACOCKPIT.

I managed to get these data, but I am confused as several numbers are displayed.

In SQL server I had 3 numbers:

-data size

- index size

- reserved size, which is the sum of data and index size.

Now I get:

Space allocation (data)

- reserved total

- used total

- data total

- data utilized total

- and some others

Space allocation (index total)

- reserved total

- used total

- data total

- data utilized

What do these numbers mean? ( I looked on sap help, but there I only find a very short description which does not explain what the numbers mean.)

Is any of these displayed numbers comparable with what I had on MSS?

Thanks a bunch!

[former_member198560 · Accepted solution]

rowtotal -> Reports an estimate of the number of rows. The value is read from the OAM page. Though not always exact, this estimate is much quicker and leads to less contention than select count(*).

reserved -> Reports pages reserved for use by the table and its indexes. It includes both the used and unused pages in extents allocated to the objects. It is the sum of data, index_size, and unused.

data -> Reports the kilobytes on pages used by the table.

index_size -> Reports the total kilobytes on pages used by the indexes.

unused -> Reports the kilobytes of unused pages in extents allocated to the object, including the unused pages for the object's indexes.

Hope this will be helpful.

~Gaurav

[Former Member · Accepted solution]

Here is a screenshot:

If I'm not mistaken, the "Reserved Total" beneath "Space Allocation (Data)" is not the dat + index size because "Reserved Total" for indexes is larger.

So I was thinking that "Data Utilized Total" is the sum of data + indexes.  But it does not add up somehow.