Are there "database workload capture & replay"-products for SQL Anywhere 12 (like, for example, "Real Application Testing" for Oracle databases or iReplay for Sybase ASE)?
asked 11 Feb '13, 06:59
Internal database client packet-level replay tools do exist in technical support. However, we do not publicly distribute these tools with SQL Anywhere - they are generally for internal use (or would be provided directly to customers via a technical support case). Externally, we expect these tools to be used for diagnostic purposes only, in scenarios where the interaction between the database server and database client isn't fully understood and we are trying to capture the client-level protocol behaviour for later analysis.
May I ask what the background is for this question? Is this intended for a performance test?
If you are trying to create a performance test, you may want to take Volker's advice but modified slightly: you will likely also want to consider all requests to the database server (including SELECTS), so relying on just the transaction log will miss out on any operations that do not change data. You should run a request-level log capture (
answered 11 Feb '13, 09:15
What about translating the transaction log with DBTRAN (possibly for a certain log offset range and including/excluding particular users) and run the generated SQL against a backup of the database that does not already contain these operations?
I.e. in a very simple scenario:
answered 11 Feb '13, 07:30