SYBASE ASE status command

[Former Member]

Hi Experts,

1- I would like to know is there any command or isql query to find out the Sybase ASE database status,?

[Former Member]

Hi Halford, Kimon

Thank you....

[former_member188958]

The "sp_helpdb" stored procedure gives information on the current status of a database.

[kimon_moschandreou]

There is not a single command or procedure to provide something like a dashboard of the system. You need to run several commands in order to check the various aspects (disk space, mem usage etc) of a database server. Sybase Control Center provides such a dashboard in a web page, which is the result of several queries

Kimon