Load Editor

From DB Optimizer
Jump to: navigation, search

Load editor icon.PNG

The load editor can be run either with "File -> New -> Load Editor" or with the load editor icon shown above in the red square. The icon represents an RPM meter on a car with red line. The idea of the icon is that we can run a load on a database and stress the database with the load similar to red lining.

Load editor.PNG

The load editor page has space on the left to show the sql to be run. The sql can be typed in or pasted in or read from a file if "SQL File" option clicked.

On the left are options on how to run the SQL

  • Number of users
  • Length of test
    • length of time
    • or
    • Number of loops

Sleep between loops

  • No sleep
  • Fixed sleep
  • Random sleep between a max and min


Write SQL with Editor
Set up Load with Load Editor
Kick of profiling the database
Run the load in the Load Editor
Verify the database load profile to see if there are any major issues