Page Comparison

...

STATS_TYPE	INITIATOR_TYPE	INITIATOR_ID	INITIATOR_NAME	FULL_CONTEXT	DATA_TYPE	DATA_VALUE
Activity	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	TaskPlan/Action Name	numStarted	{Number of tasks started in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab Stats DB Logging Seconds field}
Activity	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	TaskPlan/Action Name	numActive	{Number of tasks still running at the end of this timeslot. The timeslot is set in the System Configuration > System Tuning Tab - Stats DB Logging Seconds field}
Activity	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	TaskPlan/Action Name	numEnded	{Number of tasks ended in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab - Stats DB Logging Seconds field}
Activity	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	TaskPlan/Action Name	sumDuration (milliseconds)	{Total duration of task ending in this timeslot. The timeslot is set in the System Configuration > System Tuning Tab - Stats DB Logging Seconds field}

This is a record of data volumes written to Streams and Exporters

STATS_TYPE	INITIATOR_TYPE	INITIATOR_ID	INITIATOR_NAME	CONTEXT_TYPE	CONTEXT_ID	CONTEXT_NAME	FULL_CONTEXT	DATA_TYPE	DATA_VALUE
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	insertCount	{Count of database insert batches}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	insertVolume	{Volume of individual records inserted}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	insertVolumeBytes (bytes)	{Volume of records bytes inserted}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	insertTimeTotal (milliseconds)	{Time taken to insert records}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	updateCount	{Count of database updated batches}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	updateVolume	{Volume of individual records updated}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	updateVolumeBytes (bytes)	{Volume of records bytes updated}
Stream	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Stream	Stream ID	Stream Name	TaskPlan/Action Name.Stream Name	updateTimeTotal (milliseconds)	{Time taken to update records}

The timeslot is set in the System Configuration > System Tuning Tab

Stats DB Logging Seconds field

This is a record of Pipe Read Statistics

STATS_TYPE	INITIATOR_TYPE	INITIATOR_ID	INITIATOR_NAME	CONTEXT_TYPE	CONTEXT_ID	CONTEXT_NAME	FULL_CONTEXT	DATA_TYPE	DATA_VALUE
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	readCount	{Numer of reads}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	readTime (milliseconds)	{Time taken to read}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	readTimeMax (milliseconds)	{Maximum read time}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	readRecCount	{Number of records read}

...

STATS_TYPE	INITIATOR_TYPE	INITIATOR_ID	INITIATOR_NAME	CONTEXT_TYPE	CONTEXT_ID	CONTEXT_NAME	FULL_CONTEXT	DATA_TYPE	DATA_VALUE
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	sumEnqueueTime (milliseconds)	{Time take to add to queue}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	enqueueCount	{Pipe added to queue}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	sumDequeueTime (milliseconds)	{Time take to remove from queue}
Pipe	TaskPlan, Action	TaskPlan/Action ID	TaskPlan/Action name	Pipe	Pipe ID	Pipe Name	TaskPlan/Action Name.Stream Name.pipe Name	dequeueCount	{Pipe removed from queue}

...

Versions Compared