4

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).
Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
Ismael
  • 2,330
  • 1
  • 25
  • 37

2 Answers2

4

The quickest way would actually be to upgrade your SQL Anywhere to v10 or (better) v11, as the latest releases include a complete performance diagnostic toolset. See the documentation here for more details.

Tom Slee
  • 940
  • 1
  • 9
  • 13
2

several open source tools are listed here:

http://www.opensourcetesting.org/performance.php

David
  • 72,686
  • 18
  • 132
  • 173