Geek Answers Handbook

How to properly check the performance of your high-load database?

I found many topics about the stress testing web application.

My goals are different, it is only checking the database (sybase sql anywhere 9).

What I need:

  • Some tool to give a diagnosis of all sqls and find a bottleneck. I wish I could easily view the entire system.
  • Recommendations for developing / building good SQL queries.

System problems:

  • The database size is 20 GB.
  • 2-5 queries per second
  • Thysands sql is distributed in code (this mess can only be resolved to rewrite the system).
+4
source share
2 answers

Here are a few open source tools:

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

+2
source

The fastest way is to upgrade your SQL Anywhere to version 10 or (better) v11, as recent releases include a complete set of performance diagnostics tools. See the documentation here for more details.

+4
source

More articles:


All Articles