> I am currently encountering performance with my Sybase ASE 12.0. Since
> the application was bought, I can't look at the data model. I am looking
> for some monitoring tool, that could give stats on which and how often
> tables, indexes, proc stocked are used. I have heard about Cyrano, but
> since the company bankrupt few months ago, I am not sure I'll be able to
> find a trial. Does anyone know what tool I could use?
You can do various things.
First, you should be able to extract the data model from the database
itself (unless the vendor has used sp_hidetext to scramble the source to
the datamodel, etc.) - there are various free tools to do so, among them
dbschema.pl, a perl script (see http://www.midsomer.org for details).
You can also turn on auditing for the database in question. This should
allow you to record all or part of the database activity. See the Sybase
System Administration manual for details on how to turn on auditing.
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
International Sybase User Group - http://www.isug.com