I am trying to run Sybase SQL Expert for monitoring our ASE 12.5
database server. I am running the monitor server along with the dataserver. I have been running many long running queries while the SQL expert was monitoring. It did not detect any single sql statement I ran. Can anybody help me to configure the SQL Expert ? I have set the event buffer per engine as 6000 and max sql text to be monitored as 4096.
SQL Expert is not a monitoring tool. It is used to optimize the SQL with abstract plans.
If you are after a GUI based SQL monitoring tool for Sybase, checkout the new DB-Xray. This is a GUI based monitoring tool, that feeds off Monitor Server and displays very impressive report with charts and interactive graphs.