Tables [dbo].[wtCACMO_VCHost]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:11 PM Saturday, July 19, 2008
Last Modified2:46:11 PM Saturday, July 19, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
uuidbinary(16)16
No
VPM_Property1varchar(255)255
Yes
VPM_Property2varchar(255)255
Yes
VPM_Property3varchar(255)255
Yes
VPM_Property4varchar(255)255
Yes
VPM_Property5varchar(255)255
Yes
Cluster_Namevarchar(255)255
Yes
Cluster_Typevarchar(64)64
Yes
Manage_Clusterint4
Yes
Log_Levelint4
Yes
Log_File_Sizeint4
Yes
Console_Message_Levelint4
Yes
CMO_Portint4
Yes
Analysis_Intervalint4
Yes
Poll_Intervalint4
Yes
Manager_Hostvarchar(64)64
Yes
DRSLvarchar(64)64
Yes
SCLvarchar(64)64
Yes
Manage_Nodeint4
Yes
CPU_Weight_Coefficientvarchar(64)64
Yes
LA_Weight_Coefficientvarchar(64)64
Yes
Real_Memory_Weight_Coefficientvarchar(64)64
Yes
Current_CPUvarchar(64)64
Yes
CPU_Warn_Thresholdint4
Yes
CPU_Critical_Thresholdint4
Yes
Current_Memoryvarchar(64)64
Yes
Used_Memoryvarchar(64)64
Yes
Total_Memoryvarchar(64)64
Yes
Node_Namevarchar(255)255
Yes
Node_Idvarchar(255)255
Yes
Node_Statusvarchar(64)64
Yes
Memory_Warn_Thresholdint4
Yes
Memory_Critical_Thresholdint4
Yes
SQL Script
CREATE TABLE [dbo].[wtCACMO_VCHost]
(
[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,
[Cluster_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cluster_Type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manage_Cluster] [int] NULL,
[Log_Level] [int] NULL,
[Log_File_Size] [int] NULL,
[Console_Message_Level] [int] NULL,
[CMO_Port] [int] NULL,
[Analysis_Interval] [int] NULL,
[Poll_Interval] [int] NULL,
[Manager_Host] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DRSL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCL] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manage_Node] [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,
[Current_CPU] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CPU_Warn_Threshold] [int] NULL,
[CPU_Critical_Threshold] [int] NULL,
[Current_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Used_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total_Memory] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Node_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Node_Id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Node_Status] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Memory_Warn_Threshold] [int] NULL,
[Memory_Critical_Threshold] [int] NULL
) ON [PRIMARY]
GO
Uses