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
Sample Output:
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
Sample Output:
Job Stats query
...
:
- Overview of jobs showing the counts for each stage (Awaiting Confirmation, Queued, Served, etc.)
Script: Job Stats.sql
heightSample Output:
250
Queued Jobs Analysis
...
:
- Tracks items which reach a queued state and gives some indication as to
- how quickly jobs are served
- if items are staying queued and blocking spots in the queue
- the average time between being queued and served
- the longest un-served item
Instructions: Run the script for 5 minutes, then stop. Scroll to the bottom of the script and execute the Trending Results section. Execute the drop temp tables section after capturing the output.
Script: Queued Jobs Analysis.sql
heightSample Output:
250
Job Data Summary:
...
- Displays server info, current summary of the state of the jobs, and shows active jobs.
Script: Job Data Summary.sql
heightSample Output:
250
Average Scan and Save times grouped per Month/Day/Hour
...
- Displays the average scan, save and total number of counts per hour
Script: averagescantimes.sql
heightSample Output:
250
Job Execution Time Query:
...
- Displays the elapsed Time in hours for In Progress Jobs
Script: Job_Execution_Time_Query.sql
heightSample Output:
250
Job Serving Analysis:
...
- Displays number of jobs queued, capacity, number of jobs waiting and average time.
Script: Job Serving Analysis.sql
heightSample Output:
250