To review and monitor the Adaptive Server Anywhere is necessary to have knowledge of their commands. What are the basic commands necessary for identifying and setting to adjust the performance of a Sybase database? |
Glenn's (old) blog has a section that includes several whitepapers on performance diagnostics: |
There are a lot of different approaches and several tools available. There is quite a lot of help in the documentation - this is probably a good place to start: Performance improvements, diagnostics, and monitoring Also: How can I make it faster helps with what approach to take to a particular problem. |