Benchmark execution is the phase during which you tune your database by iteratively running a test, modifying something about the database (for example, the value of one or more database properties or connection parameters), and then running the test again to see the outcome of any changes.
There are no prerequisites for this task.
Context and remarks
The following procedure assumes you are testing different database properties and/or connection parameters to find the maximum benefit. Repeat this procedure until all parameters that require testing have been tested.
Choose only those properties or parameters that are significant to the workload and the objectives of your UltraLite deployment.
Create a baseline by running the first iteration of the test. In this case, because you are testing different database properties and/or connection parameters, you would use UltraLite defaults wherever possible.
Begin your normal test runs by tuning only one database property or connection parameter at a time. This limitation ensures that the results you collect are systematic in their approach and helps you more readily determine when you have reached the maximum benefit of your tuning activities.
Output from the benchmark program should include:
an identifier or label for each test
the iteration of the program execution
the name of the element being checked and what you did to change it
the recorded elapsed time
For example, even though you could test other database parameters, if you limited your test to just varying page sizes, cache sizes, and reserve sizes, your output might be saved to a table that looks similar to the example that follows:
PROP/PARM VALUES TEST NUMBER 001 002 003 page_size 1 2 8 CACHE_SIZE 128 256 512 RESERVE_SIZE 128 256 512 STMT ID EXECUTION (seconds) 01 01.55 01.50 01.49 02 02.01 02.20 01.59 03 00.33 00.55 00.44
When you have completed an iteration, return the database to the baseline state to ensure you do not inadvertently contaminate results of subsequent runs.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|