Versions Compared

Key

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

The scripts listed on this page are to be used in Customer environments to allow us to start collating output counts and begin mapping trends across various iQsonar set-ups.  Additional sections will be added to this page once results from customers are available.  The goal is to help with customer fine tuning and also will assist both Support and Development with designing best practice.  

Timings Test for Targets Serve:

  • Use to check how long the Targets Serve stored proc runs each step (in ms)

Script:

 

View file
nameTargets_Serve_test.sql
height250

Sample Output:

Image Added

Timings test for QueueStep2

  • Use to see how long each step of the Queue_Step2 Stored Proc takes to complete (in ms)

Script:

 

View file
nameQStep2_Test.sql
height250

Sample Output:

Image Added

Job Stats query

View file
nameJob Stats.sql
height250

...