sp_monitor - statistics about SAP ASE Server

sp_monitor displays statistics about SAP ASE Server.

It can run with few options:

1. General information about how busy the Server has been:

sp_monitor

go

2. Information about connections:

sp_monitor "connection"

go

sp_monitor "connection","diskio"

go

3. Information about statements:

sp_monitor "statement"

go

4. Information about the most recently run procedures:

sp_monitor "procedure"

go

* and more.....

More details in SAP site.