Help > Views > V_ThroughputDetail

View: V_ThroughputDetail

This view shows the time elapsed from check-out to check-in per service type (ServiceType), as well as worker performance for the elapsed time.

Example: SeviceType=0 (Activity) and SumDurationHours is 0.5 hours, so the "worker" of the "Activity" Service processed the documents for 0.5 hours.

Column	Description
ServiceType	0 = Activity 1 = Collector 2 = Agent 3 = Global Parameter Set 4 = Client Parameter Set 5 = Process Parameter Set 6 = Interactive 7 = Platform 8 = License 9 = Activity and Parameter Set 10 = Feature Group (ServiceType in V_SumDuration)
SumDurationHours	The number of hours in which the documents for this step were checked out. (The sum of SumDurationHours in V_SumDuration.)
DocumentCount	The number of documents for one service type (the sum of DocumentCount in V_SumDuration).
ThroughputHours	The number of documents for one service type, divided by the number of hours in which the documents were checked out. (The sum of DocumentCount/sum of SumDurationHours in V_SumDuration.)

SQL Script

CREATE VIEW [dbo].[V_ThroughputDetail]
AS
SELECT ServiceType, SUM(SumDurationHours) AS SumDurationHours, SUM(DocumentCount) AS DocumentCount, SUM(DocumentCount)
	         / SUM(SumDurationHours) AS ThroughputHours
FROM   dbo.V_SumDuration
GROUP BY ServiceType

Uses

V_SumDuration

The available tables

The available views