[dbo].[wtVPM_LDOM

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	2:46:12 PM Saturday, July 19, 2008
Last Modified	2:46:12 PM Saturday, July 19, 2008

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
VPM_Property1	varchar(255)	255
VPM_Property2	varchar(255)	255
VPM_Property3	varchar(255)	255
VPM_Property4	varchar(255)	255
VPM_Property5	varchar(255)	255
VPM_Property6	varchar(255)	255
VPM_Property7	varchar(255)	255
VPM_Property8	varchar(255)	255
VPM_Property9	varchar(255)	255
VPM_Property10	varchar(255)	255
Platform_Name	varchar(64)	64
Platform_Type	varchar(64)	64
DRO_Server_Host	varchar(64)	64
DRSL	varchar(64)	64
DRSLG	varchar(64)	64
SCL	varchar(64)	64
SCLG	varchar(64)	64
Manage_Platform	int	4
Log_Level	int	4
Log_File_Size	int	4
Console_Message_Level	int	4
Main_SSP_Name	varchar(64)	64
DRO_Port	int	4
CPU_Weight_Coefficient	varchar(64)	64
LA_Weight_Coefficient	varchar(64)	64
Real_Memory_Weight_Coefficient	varchar(64)	64
Analysis_Interval	int	4
Poll_Interval	int	4
Domain_Usage_Upper_Limit	int	4
Domain_Usage_Lower_Limit	int	4
Cur_Capacity	int	4
IO1	float	8
IO2	float	8
IO3	float	8
IO4	float	8
IO1_Min	float	8
IO1_Max	float	8
IO1_COEF	float	8
IO2_Min	float	8
IO2_Max	float	8
IO2_COEF	float	8
IO3_Min	float	8
IO3_Max	float	8
IO3_COEF	float	8
IO4_Min	float	8
IO4_Max	float	8
IO4_COEF	float	8
Disk1	float	8
Disk2	float	8
Disk1_Min	float	8
Disk1_Max	float	8
Disk1_COEF	float	8
Disk2_Min	float	8
Disk2_Max	float	8
Disk2_COEF	float	8
Mem2	float	8
Mem3	float	8
Mem2_Min	float	8
Mem2_Max	float	8
Mem2_COEF	float	8
Mem3_Min	float	8
Mem3_Max	float	8
Mem3_COEF	float	8
CPU2	float	8
CPU2_Min	float	8
CPU2_Max	float	8
CPU2_COEF	float	8
Net1	float	8
Net2	float	8
Net1_Min	float	8
Net1_Max	float	8
Net1_COEF	float	8
Net2_Min	float	8
Net2_Max	float	8
Chassis_Serial_Number	varchar(64)	64
Firmware	varchar(64)	64
Hypervisor	varchar(64)	64
Open_Boot_Prom	varchar(64)	64
POST	varchar(64)	64
Total_CPU_Cores	varchar(64)	64
Total_Memory	varchar(64)	64
Total_Free_CPU_Cores	varchar(64)	64
Total_Free_Memory	varchar(64)	64
Current_Memory	varchar(64)	64
Memory_Warn_Threshold	int	4
Memory_Critical_Threshold	int	4
Current_CPU	varchar(64)	64
CPU_Warn_Threshold	int	4
CPU_Critical_Threshold	int	4
Domain_Name	varchar(64)	64
Domain_Node	varchar(64)	64
Domain_Status	varchar(64)	64
Domain_Type	varchar(64)	64
Domain_Platform	varchar(64)	64
Domain_OS	varchar(64)	64
Domain_Boards	varchar(64)	64
Domain_Boards_Change	varchar(64)	64
Manage_Domain	int	4
SysAgt_PollInt	int	4

SQL Script

CREATE TABLE [dbo].[wtVPM_LDOM_Memory]
(
[uuid] [binary] (16) NOT NULL,
[VPM_Property1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Platform_Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Platform_Type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRO_Server_Host] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRSL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRSLG] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCLG] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manage_Platform] [int] NULL,
[Log_Level] [int] NULL,
[Log_File_Size] [int] NULL,
[Console_Message_Level] [int] NULL,
[Main_SSP_Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRO_Port] [int] NULL,
[CPU_Weight_Coefficient] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LA_Weight_Coefficient] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Real_Memory_Weight_Coefficient] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Analysis_Interval] [int] NULL,
[Poll_Interval] [int] NULL,
[Domain_Usage_Upper_Limit] [int] NULL,
[Domain_Usage_Lower_Limit] [int] NULL,
[Cur_Capacity] [int] NULL,
[IO1] [float] NULL,
[IO2] [float] NULL,
[IO3] [float] NULL,
[IO4] [float] NULL,
[IO1_Min] [float] NULL,
[IO1_Max] [float] NULL,
[IO1_COEF] [float] NULL,
[IO2_Min] [float] NULL,
[IO2_Max] [float] NULL,
[IO2_COEF] [float] NULL,
[IO3_Min] [float] NULL,
[IO3_Max] [float] NULL,
[IO3_COEF] [float] NULL,
[IO4_Min] [float] NULL,
[IO4_Max] [float] NULL,
[IO4_COEF] [float] NULL,
[Disk1] [float] NULL,
[Disk2] [float] NULL,
[Disk1_Min] [float] NULL,
[Disk1_Max] [float] NULL,
[Disk1_COEF] [float] NULL,
[Disk2_Min] [float] NULL,
[Disk2_Max] [float] NULL,
[Disk2_COEF] [float] NULL,
[Mem2] [float] NULL,
[Mem3] [float] NULL,
[Mem2_Min] [float] NULL,
[Mem2_Max] [float] NULL,
[Mem2_COEF] [float] NULL,
[Mem3_Min] [float] NULL,
[Mem3_Max] [float] NULL,
[Mem3_COEF] [float] NULL,
[CPU2] [float] NULL,
[CPU2_Min] [float] NULL,
[CPU2_Max] [float] NULL,
[CPU2_COEF] [float] NULL,
[Net1] [float] NULL,
[Net2] [float] NULL,
[Net1_Min] [float] NULL,
[Net1_Max] [float] NULL,
[Net1_COEF] [float] NULL,
[Net2_Min] [float] NULL,
[Net2_Max] [float] NULL,
[Chassis_Serial_Number] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Firmware] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Hypervisor] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Open_Boot_Prom] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[POST] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total_CPU_Cores] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total_Free_CPU_Cores] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total_Free_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Current_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Memory_Warn_Threshold] [int] NULL,
[Memory_Critical_Threshold] [int] NULL,
[Current_CPU] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CPU_Warn_Threshold] [int] NULL,
[CPU_Critical_Threshold] [int] NULL,
[Domain_Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Node] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Status] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Platform] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_OS] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Boards] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domain_Boards_Change] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manage_Domain] [int] NULL,
[SysAgt_PollInt] [int] NULL
) ON [PRIMARY]
GO