Creating a benchmark testing scenario

Creating a benchmark does involve lots of resources, including application developers and database administrators. The extra time it takes can have maximum returns in the long run. We suggest you consider this option if you are developing an application.

If your IT department is using an ERP such as JD Edwards or SAP, you can also benefit from this approach. A benchmark is useful because it helps you define a controlled environment in which you can have repeatable tests.

You can test deadlock scenarios, table space configurations, or database parameters. The same conditions and tests help you pinpoint, accurately, the best options for tuning your databases.

Getting ready

Allow for hardware and software resources, and time for an implementation team, with project lead, application developers, and system and database administrators. Make this part of your implementation project, or it could even be considered as a project on its own.

Have representative SQLs...