Benchmark Testing

Benchmark Testing is a part of SDLC which involves both developers and database administrators (DBAs) to determine current performance and make changes to improve the performances. Benchmarks should imitate particular part of workload. There are different parts of software that should be benchmarked to make performance changes: SQL Queries, SQL Indexes, SQL Procedures, SQL Triggers, Table Space Configurations, Hardware Configurations, Application Code, Networks, Firewalls. Benchmark testing is performed under the same parameters because the results should be compared. Characteristics of Benchmarks: repeatable tests, the same environmental conditions, no other active applications, all the specifications should be kept.