Why is the output for Database Sizes and Transaction Logs sizes different from Sybase stored procedures like sp_helpdb and sp_spaceused?
In these two tables, the space for data and logs is separated as much as possible to allow a clearer picture of your database. For the Sybase stored procedure sp_spaceused, the ‘database_size’ field is the sum of all devices allocated for the database, and the ‘data’ field is the sum of the sizes of all data objects in the database, including transaction logs. For the stored procedure sp_helpdb, the ‘size’ field is the size of each device allocated for the database, and the ‘free kbytes’ field is the amount of space left unreserved on that device. In the PrimeAlert for Sybase module, the ‘Total’ field in the Database Sizes table is the sum of all devices specifically allocated for data (devices that sp_helpdb would report as being ‘data only’ and ‘data and log’). The ‘Total’ field in the Transaction Logs table is the sum of all devices allocated for logs (devices that sp_helpdb would report as being ‘log only’ or ‘data and log’. The procedure sp_spaceused reports the sum of sizes of al
