× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2009-02-18T23:40:59Z  · last modified 2009-02-27T00:45:44Z

Sybase ASE 15 Table Size in Object Tab


Priority Low
Complexity Unknown
Component DBA-T - Sybase - Storage Mngr
Version 07.5

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

2 attachments

Issue #2349

Closed
Fixed
Resolved 2009-02-27T00:45:44Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017