database usage

[dwcasey]

Running 12.5.2. Is there a way to pull stats out of Sybase to see usage? We have a GUI client tool that about 15-20 use to connect to a certain database in Sybase.

I would like to know information like how has/is connecting. as well as database and possibly table usage.

Which table is hit the most, that sort of stuff.

I'm already tracking the system utilization for trend analysis, but not sure what to do for the Sybase db.

Thanks.

 

[micha123]

I see your post is a little old, and I don't know if you still need help.
You can install the auditing database, and audit everything that occurs there. It will degradate performance a little bit, but it will do what you want.

If you don't want to do that, there are some manual things you can do, but you would have to do some T-SQL coding.
Do you need me to help you on that?

M.