Chatta subito con l'assistenza
Chat con il supporto

Benchmark Factory for Database 9.0 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

SQL Scalability Testing from Toad

Note: To run SQL Scalability testing from Toad you must have Benchmark Factory installed. The Benchmark Factory console does not have to be open to run SQL Scalability testing.

Overview

The SQL Scalability test allows you to execute SQL statements, letting users spot potential issues not seen with a single execution. Users can run variations of a SQL statement generated by SQL Tuning in order to find the SQL that will perform the best under a load test.

Creating a SQL Scalability load scenario requires the following steps.

  1. Creating the SQL tuning connection
  2. Entering the desired SQL statement
  3. Running the statement using the Benchmark Factory SQL Scalability testing

Creating the SQL tuning connection

To create the SQL Turning connection

  1. In Quest Central or Toad for Oracle, connect to an Oracle or SQL Server database.
  2. From the Quest Central main toolbar select Tools|SQL Tuning to launch.

Entering the desired SQL statement

To enter the desired SQL statement

  1. Enter the desired SQL statement in SQL Text.
  2. Click the Optimize Statement icon. Clicking this icon executes multiple syntax transformation rules to produce a list of semantically equivalent SQL statements.   

Running the SQL statement using the in Benchmark Factory SQL Scalability Testing

  1. Click the Benchmark Factory drop-down icon and select the desired option. Three options are provided:
  2. Test for Scalability-Tests the currently displayed SQL.
  3. Test All for Scalability-Tests all SQL statements.
  4. Test Selected for Scalability-Tests the selected SQL statements.
  1. The Benchmark Factory SQL Scalability dialog displays. Click Next. The Measurement Interval dialog displays.
  2. Enter the desired user load.
  3. Click Next. The Iteration Length dialog displays.
  4. Enter the desired number of executions per iterations or executions per iteration.
  5. Click Next. The Real World Latencies dialog displays.
  6. Select the desired latency.
  7. Click Next. The connection information dialog displays.
  8. Enter the connection parameters.
  9. Click Next. The Connection Agent dialog displays. Benchmark Factory Agent(s) reside on each physical client machine and spawn multiple virtual-user sessions. Each Agent generates an information screen with tabs that contain a variety of Agent information. Benchmark Factory can control hundreds of Agent machines.
  10. If there are more than 20 users in your test, you will need to run an agent. Click Start Local Agent.
  11. Click Next. The Benchmark Factory SQL test completion dialog displays.
  12. Click Finish. The SQL Scalability dialog displays. From this dialog, you can control, monitoring, and view SQL testing results. This dialog provides the following tabs and buttons:

Overview Tab

The Overview tabs provides transactions per second testing results for individual user loads and iterations.

Transactions

The Transactions view provides the following statistics on the SQL statements being run:

  • Executions
  • Rows
  • Bytes
  • Errors
  • Average Transaction Time
  • Minimum Transaction Time
  • Maximum Transaction Time

Real-Time

Real-Time Statistics provides real-time graphs and raw data. This data allows you to spot system-under test issues that may be affecting server performance.  Right-clicking inside the graph displays a drop-down that allows you to change graph settings and view.

Summary

The Summary graph provides real-time and raw data summary graphs. The Summary graph displays real-time counter data. Right-clicking inside the graph displays a drop-down that allows you to change graph settings and view.

 

Messages

The Output window displays messages about the job being run.

 

Test Database Scalability

To test SQL Scalability, select one of the following:

To test a system using standard benchmark tests, see the following:

 

Settings

About

Use the Settings dialog to specify or view the default settings Benchmark Factory uses when you create a new job. Changes to these settings affect only new jobs, not existing jobs.

To specify Benchmark Factory settings

  1. Select Edit | Settings. The Settings dialog opens.
  2. Select a category from the list in the left pane. You can specify settings for the following:

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione