Search Results

Contents Linear Scalability in Test Servers The Methodology Transforming Calibration Results to TPS Mitigations Rapidly Determine The Scale Of A Performance Test The Appvance Calibration Testing Methodology is an important step in determining app s...

Start a performance test too high and the test delivers results that are a function of a performance bottleneck in the test server itself and not the application under test. Start too low and the results may not hit the upper limits of your app performance and...

Here are the steps to this methodology: Determine a starting number of concurrently running virtual users. I use ...

Apps are increasingly used as part of marketing campaigns to engage customers in brands. Brand managers and business managers typically do not talk in terms of virtual users and transactions per second. For example, PepsiCo's brand manager for a Mountain Dew a...

Calibration testing focuses on throughput measured from the client (load-generation) equipment. Monitoring resource usage—including CPU, network, and memory—on both the client and server during a calibration test can help identify and diagnose performance issu...

Contents How to Create a Valid SQL Script Setting up the Environment Creating a New Database Scenario Execution Results Sample SQL Scripts Reduce Size and Free Up Storage in MySQL Results Database Appendix Appvance SQL Client ...

To create a valid SQL script in Appvance AIQ, you must configure the database connection properties correctly. These properties are based on Hibernate and are used to map the database configuration and establish a connection through the appropriate JDBC driver...

Now let’s see how to create an SQL script using the required configuration settings. In this example, we use a MySQL database named appvancetest with a worker table containing the following columns: idworker name lastname The database can be hosted on a loca...

Once you have created a valid SQL script, you can create an AppVance Scenario to execute it using the Scenario Builder. This article assumes basic knowledge of AppVance Scenario Builder and focuses only on the configuration required to create a Database Scenar...

This section explains how to review the results of a SQL test execution and how to customize the step names displayed in the execution results. In this example, the SQL test inserts a new record into the database and then retrieves the records using a SELECT ...

MySQL with limit -- dbvendor=MYSQL -- username=aiq -- password=thePassword -- host=mysqlsmoketest.c7nn5t4czzya.us-west-2.rds.amazonaws.com -- schema=aiq -- port=3306 ...

Reduce MySQL Results Database Storage Usage Use this procedure when the AIQ results database is consuming excessive storage. Treat database cleanup as a controlled maintenance task because deleting execution data can permanently remove historical evidence and ...

Recommended guidance Use the SQL Testing appendix for supplemental reference material that supports active SQL testing workflows. Keep appendix content concise, current, and linked to the main SQL testing guidance. What belongs here Reference examples that are...

Contents Appvance DPL Types Configuring Appvance DPLs Providing Data to Distributed Tests Dynamic DPL Array Generator DPL WhiteBoard DPL Scenario Wide DPL Hash DPL JavaScript DPL Using the DPLs Communication Intra-Steps Using TheLocker The RSC Resource Creatin...

Recommended guidance DPLs provide operational test data for AIQ scenarios and services. Choose the DPL type based on data ownership, repeatability, volume, security, and whether values are static, generated, or retrieved from an external system. Common DPL con...

AIQ implements a Data Production Library (DPL) as an extensible framework to provide operational test data to test script runners at test runtime. The DPL framework is general in the sense that it can get data from a variety of sources, including a relational ...

AIQ is a distributed test system. Multiple virtual users run in a TestNode and tests run across one or more TestNodes. Tests often need unique data for each virtual user. For example, a test of a banking system needs a separate and unique customer number for e...

Configure Dynamic DPL Data Use a Dynamic DPL when a Scenario Editor test needs generated values at runtime, such as random numbers, generated strings, timestamps, or values within a defined range. Dynamic DPLs are useful when the test data does not need to com...