Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Run the load editor can be run by using either with File > New > SQL Load or with the New SQL Load icon shown above in the red square.

...

On the right are options on how to run the SQL:

  • Number of parallel sessions
  • Length of test
  • Number of executions executions
  • Sleep between executions
    • No sleep
    • Fixed sleep
    • Random sleep between a max and min

Methodology

  1. Write SQL with Editor
  2. Set up Load with Load Editor 
  3. Kick off profiling the database 
  4. Run the load in the Load Editor 
  5. Verify the database load profile to see if there are any major issues 

The SQL Load Editor/Tester enables you to configure and execute SQL code against a data source.

...