I did an update statistics for all tables in example_data and then compared sp_spaceused stored procedure with ADS Storage Manager Table Size and it didnt match.
I picked tables in Random and the Table Size of ADS storage manager didnt match with sp_spaceused. I have attached 2 pics which displays the difference easily. Out of 6 tables only 1 table logins matched entirely but all other had differences.
note - I did a comparison with size in MegaBytes(MB) for Object Tabs (which has been already reported)
Sybase ASE 15.0 - 46
Database example_data
User Tables
================================================================================
sp_spaceused TABLE_EDITOR
go
name rowtotal reserved data index_size unused
------------ ----------- ----------- ------- ------------- ---------
TABLE_EDITOR 7 64 KB 4 KB 18 KB 42 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
TABLE_EDITOR 21 64.00 12.00 22.00 42.00
================================================================================
sp_spaceused KANJIDATA
go
name rowtotal reserved data index_size unused
--------- ----------- ----------- ------- ------------- ---------
KANJIDATA 0 32 KB 2 KB 2 KB 28 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
KANJIDATA 0 16.00 2.00 2.00 14.00
================================================================================
sp_spaceused syscomments
go
name rowtotal reserved data index_size unused
----------- ----------- ----------- ------- ------------- ---------
syscomments 778 318 KB 252 KB 34 KB 32 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
syscomments 1,556 318.00 504.00 286.00 32.00
================================================================================
sp_spaceused logins
go
name rowtotal reserved data index_size unused
------- ----------- ----------- ------- ------------- ---------
logins 0 16 KB 2 KB 0 KB 14 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
logins 0 16.00 2.00 0.00 14.00
================================================================================
sp_spaceused EMPL1
go
name rowtotal reserved data index_size unused
------- ----------- ----------- ------- ------------- ---------
EMPL1 0 144 KB 2 KB 16 KB 126 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
EMPL1 0 144.00 10.00 18.00 126.00
================================================================================
sp_spaceused alloc_pool_pos
go
name rowtotal reserved data index_size unused
-------------- ----------- ----------- ------- ------------- ---------
alloc_pool_pos 0 142 KB 2 KB 16 KB 124 KB
ADS Object Tab
Table Name Row Count Reserved (MB) Data (MB) Indexes (MB) Unused (MB)
alloc_pool_pos 0 142.00 10.00 18.00 124.00
|
20 KB
|
21 KB
Fixed in 7.4.63
Issue #2349 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Fixed in 7.4.63