This sample PowerShell script demonstrates some basic functionality of the Benchmark Factory REST API such as creating a performance job, in this case a SQL scalability test which executes a single SQL statement under load, executing this newly created job using an already defined connection, and, after the job execution, validates that the response time of the SQL does not exceed a set Service Level Agreement, SLA, value.

BMF REST SQL Scalability Oracle Sample.ps1

About the Author

Kevin Dalton

Kevin Dalton is a Senior Software Development Engineer at Quest Software, where, for 20+ years, he has been the Benchmark Factory for Database Development Manager. Now working as a product architect for a variety of products, he has experience with several database technologies including Oracle, SQL Server, MySQL, SAP, IBM UDB, and others. Kevin also has experience in Database DevOps and the implementation of Continuous processes to database development.

Notable Replies

  1. says:
    jeferson.senci

    Hi Kevin, can you please post an example using the BMF 8.4 ?