I have found a lot of topics about stress-testing web application.
My goals are different, it's to test only database (sybase sql anywhere 9).
What I need:
- Some tool to give a diagnostic of all sqls and find a bottleneck. I wish I could macro-view the entire system easily.
- Best practices to design/build a good sql queries.
The system issues are:
- 20GB database size.
- 2-5 request per second
- Thousands sql spread in the code (this messy can be solved only rewriting the system).