Tables [dbo].[wtVPM_ResourcePool]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:13 PM Saturday, July 19, 2008
Last Modified2:46:13 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
VPM_Property6varchar(255)255
Yes
VPM_Property7varchar(255)255
Yes
VPM_Property8varchar(255)255
Yes
VPM_Property9varchar(255)255
Yes
VPM_Property10varchar(255)255
Yes
ResPoolNamevarchar(255)255
Yes
ResPoolParentIDvarchar(255)255
Yes
ResPoolParentPathvarchar(255)255
Yes
ResPoolComputeResIDvarchar(255)255
Yes
ResPoolComputeResPathvarchar(255)255
Yes
ResPoolCPUExpandReservationvarchar(255)255
Yes
ResPoolCPUMaxvarchar(255)255
Yes
ResPoolCPUMinvarchar(255)255
Yes
ResPoolCPUSharesvarchar(255)255
Yes
ResPoolMemExpandReservationvarchar(255)255
Yes
ResPoolMemMaxvarchar(255)255
Yes
ResPoolMemMinvarchar(255)255
Yes
ResPoolMemSharesvarchar(255)255
Yes
ResPoolConfigChangeVersionvarchar(255)255
Yes
ResPoolCPUMaxUsagevarchar(255)255
Yes
ResPoolCPUOverAllUsagevarchar(255)255
Yes
ResPoolCPUReserverUsedvarchar(255)255
Yes
ResPoolCPUReserverUsedForVMvarchar(255)255
Yes
ResPoolCPUUnreservedForPoolvarchar(255)255
Yes
ResPoolCPUUnreservedForVMvarchar(255)255
Yes
ResPoolMemMaxUsagevarchar(255)255
Yes
ResPoolMemOVerAllUsedvarchar(255)255
Yes
ResPoolMemReservedUsedvarchar(255)255
Yes
ResPoolMemReservedForVMvarchar(255)255
Yes
ResPoolMemUnreservedForPoolvarchar(255)255
Yes
ResPoolMemUnreservedForVMvarchar(255)255
Yes
ResPoolStatusint4
Yes
ResPoolMonitorint4
Yes
ResPoolAlertint4
Yes
ResPoolCountint4
Yes
DatacenterNamevarchar(255)255
Yes
VC_ServerNamevarchar(255)255
Yes
ClusterNamevarchar(255)255
Yes
VMServer_Namevarchar(255)255
Yes
CPU_UnLimitedint4
Yes
MemoryUnlimitedint4
Yes
Memory_Critical_Thresholdint4
Yes
Memory_Warn_Thresholdint4
Yes
CPU_Warn_Thresholdint4
Yes
CPU_Critical_Thresholdint4
Yes
DatacenterIndexvarchar(255)255
Yes
ClusterIndexvarchar(255)255
Yes
VMServer_IDvarchar(255)255
Yes
ParentsIDListvarchar(255)255
Yes
SQL Script
CREATE TABLE [dbo].[wtVPM_ResourcePool]
(
[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,
[ResPoolName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolParentID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolParentPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolComputeResID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolComputeResPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUExpandReservation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUMax] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUMin] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUShares] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemExpandReservation] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemMax] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemMin] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemShares] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolConfigChangeVersion] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUMaxUsage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUOverAllUsage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUReserverUsed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUReserverUsedForVM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUUnreservedForPool] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolCPUUnreservedForVM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemMaxUsage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemOVerAllUsed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemReservedUsed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemReservedForVM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemUnreservedForPool] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolMemUnreservedForVM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResPoolStatus] [int] NULL,
[ResPoolMonitor] [int] NULL,
[ResPoolAlert] [int] NULL,
[ResPoolCount] [int] NULL,
[DatacenterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VC_ServerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CPU_UnLimited] [int] NULL,
[MemoryUnlimited] [int] NULL,
[Memory_Critical_Threshold] [int] NULL,
[Memory_Warn_Threshold] [int] NULL,
[CPU_Warn_Threshold] [int] NULL,
[CPU_Critical_Threshold] [int] NULL,
[DatacenterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentsIDList] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses