Knowledge Base >> How Does the Database and Transaction Log Freespace Alerts Collect Data for Sybase

How Does the Database and Transaction Log Freespace Alerts Collect Data for Sybase - Confio Article 1607

Confio Article: 1607 Published: Jul 14 2011 1:56 PM
Version: 7.0+ Topic(s): Database Problems Ignite Management Ignite Features
Product(s): Ignite
Database(s): Sybase

Ignite includes two canned administrative alerts named Database Freespace and Transaction Log Freespace. For Sybase instances, this alert uses the following for its source of data:

Sybase Database Free Space


- returns two results sets
- First: database_name, database_size (with units of MB)
- Second: reserved, data, index_size, unused (with units of KB)
- run once for each database
sp_spaceused
PercentFree = 100 - ((reserved/1024 - unused/1024) / database_size) * 100)

 

Sybase Transaction Log Free Space


- returns name (=syslogs), total_pages, free_pages, used_pages, reserved_pages
- run once for each database
sp_spaceused syslogs
PercentFree = free_pages / total_pages

Tags: log database sp_spacedused syslog reserved unused database_size free_page total_page transaction free space freespace