Using Performance Counters to Troubleshoot Survey Problems

The Forsta Plus survey engine also installs a number of performance counters that can be used to monitor and troubleshoot the web server. The counters are installed under the performance object “Confirmit Survey Engine .Net”. The following performance counters are registered:

Category	Counter name	Description
Cache	# SurveyPackages	Number of survey packages currently cached
Cache	SurveyPackage Load Time	Average time in sec used to load survey packages
Cache	SurveyPackage Turnover Rate	Number of additions and removals to the SurveyPackage cache per second
Monitor	CPU milliseconds	Average total CPU time in milliseconds used by a request
Monitor	CPU milliseconds Usercode	Average usercode CPU time in milliseconds used by a request
Monitor	Page errors/sec	Average number of survey page errors per sec
Monitor	Page hits/sec	Average number of survey page hits per sec
Monitor	Real milliseconds	Average total real time in milliseconds used to execute a request
Monitor	SQL Compile CPU milliseconds	Average CPU time in milliseconds used to compile statements
Monitor	SQL Compile Elapsed milliseconds	Average elapsed time in milliseconds used to compile statements
Monitor	SQL Execution CPU milliseconds	Average CPU time in milliseconds used to execute statements
Monitor	SQL Execution Elapsed milliseconds	Average elapsed time in milliseconds used to execute statements
Monitor	SQL Logical Reads	Average number of pages read from the data cache
Monitor	SQL Physical Reads	Average number of pages read from disk
Monitor	SQL Scan Count	Average number of scans performed
SPGen	Alter Save Proc/sec	Rate showing how many store procedures that are altered per sec
SPGen	Alter Select Proc/sec	Rate showing how many select procedures that are altered per sec
SPGen	Create Save Proc/sec	Rate showing how many save procedures that are created per sec
SPGen	Create Select Proc/sec	Rate showing how many select procedures that are created per sec
SPGen	Exec Save Proc/sec	Rate showing how many save store procedures that are executed per sec
SPGen	Exec Select Proc/sec	Rate showing how many select procedures that are Executed per sec

Using BitStream Performance Counters

The Forsta BitStream service contains several performance counters which can be utilized to troubleshoot BitStream issues. The following performance counters are registered:

Category	Countername	Description
Monitor	Write - # Currently Runinng	Current number of BitStream writing operations.
Monitor	Write - # Total Started	Total number of BitStream writing operations since service start.
Monitor	Write - % Success	Current percentage of successful BitStream write operations.
Monitor	Write – Generation Time	Current BitStream write generation time.
Monitor	Query - # Currently Running	Current number of BitStream queries running.
Monitor	Query - # Total Started	Total number of BitStream queries run since service start.
Monitor	Query - % Success	Current percentage of successful BitStream queries.
Monitor	Query – Execution Time	Current BitStream query execution time.