Views [dbo].[e2e_apm_OperationSummaryV]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:20 AM Wednesday, March 07, 2007
Last Modified11:10:20 AM Wednesday, March 07, 2007
Columns
Name
APPID
APPLICATION
OPERATION
RESPONSETIME
LOCALTIME
NETWORKTIME
SERVERTIME
COMPLETED
CANCELLED
EXCEPTION
TStamp
Permissions
TypeActionOwning Principal
GrantSelectapmadmin
SQL Script

create view  e2e_apm_OperationSummaryV AS SELECT a.app_id AS APPID, a.app_name AS APPLICATION, o.op_name AS OPERATION, r.duration AS RESPONSETIME, r.local_dur AS LOCALTIME, r.wire_dur AS NETWORKTIME, r.server_dur AS SERVERTIME, r.num_complete AS COMPLETED, r.num_cancelled AS CANCELLED, r.num_exception AS EXCEPTION, r.start_datetime AS TStamp FROM  e2e_apm_application a INNER JOIN  e2e_apm_resp_data r ON a.app_id = r.app_id INNER JOIN  e2e_apm_operation o ON r.op_id = o.op_id


GO
GRANT SELECT ON  [dbo].[e2e_apm_OperationSummaryV] TO [apmadmin]
GO
Uses