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:
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:
Sample Output:
Job Stats query:
- Overview of jobs showing the counts for each stage (Awaiting Confirmation, Queued, Served, etc.)
Script: Job Stats.sql
Sample Output:
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
Sample Output:
Job Data Summary:
- Displays server info, current summary of the state of the jobs, and shows active jobs.
Script: Job Data Summary.sql
Sample Output:
Average Scan and Save times grouped per Month/Day/Hour
- Displays the average scan, save and total number of targets per hour
Script: Average Scan Times.sql
Sample Output:
Job Execution Time Query:
- Displays the elapsed Time in hours for In Progress Jobs
Script: Job_Execution_Time_Query.sql
Sample Output:
Job Serving Analysis:
- Displays number of jobs queued, capacity, number of jobs waiting and average time.
Script: Job Serving Analysis.sql
Sample Output:
