[dbo].[e2e_adm_performance]

Property	Value
Heap
Row Count	0
Created	11:07:12 AM Wednesday, March 07, 2007
Last Modified	11:09:37 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
client_id	int	4
server_id	int	4
server_port	int	4
packet_count	int	4
packets_per_second	float	8
average_bytes_per_packet	float	8
bytes_per_second	float	8
connection_count	int	4
average_connect_time	float	8
average_transfer_time	float	8
number_of_resends	int	4
gmt_start_time	float	8
gmt_date_time	datetime	8
gmt_time_of_day	datetime	8
gmt_date	datetime	8
hourly_aggregation_done	tinyint	1
daily_aggregation_done	tinyint	1

Name	Columns
xif1e2e_adm_performance	client_id
xif2e2e_adm_performance	server_id

Type	Action	Owning Principal
Grant	Delete	apmadmin
Grant	Insert	apmadmin
Grant	Select	apmadmin
Grant	Update	apmadmin

SQL Script

CREATE TABLE [dbo].[e2e_adm_performance]
(
[client_id] [int] NULL,
[server_id] [int] NULL,
[server_port] [int] NOT NULL,
[packet_count] [int] NULL,
[packets_per_second] [float] NULL,
[average_bytes_per_packet] [float] NULL,
[bytes_per_second] [float] NULL,
[connection_count] [int] NULL,
[average_connect_time] [float] NULL,
[average_transfer_time] [float] NULL,
[number_of_resends] [int] NULL,
[gmt_start_time] [float] NULL,
[gmt_date_time] [datetime] NULL,
[gmt_time_of_day] [datetime] NULL,
[gmt_date] [datetime] NULL,
[hourly_aggregation_done] [tinyint] NULL,
[daily_aggregation_done] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1e2e_adm_performance] ON [dbo].[e2e_adm_performance] ([client_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2e2e_adm_performance] ON [dbo].[e2e_adm_performance] ([server_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_adm_performance] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_adm_performance] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_adm_performance] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_adm_performance] TO [apmadmin]
GO