Collecting SQL Server Performance and Host Performance Data - Professional SQL Server 2008 Administration with Windows PowerShell - page 412

DROP TABLE [dbo].PerfRawData_PerfOS_Processor
GO
CREATE TABLE PerfRawData_PerfOS_Processor(
Hostname varchar(100) NULL ,
___GENUS bigint NULL ,
___CLASS varchar(100) NULL ,
___SUPERCLASS varchar(100) NULL ,
___DYNASTY varchar(100) NULL ,
___RELPATH varchar(100) NULL ,
___PROPERTY_COUNT bigint NULL ,
___DERIVATION varchar(100) NULL ,
___SERVER varchar(100) NULL ,
___NAMESPACE varchar(100) NULL ,
___PATH varchar(100) NULL ,
C1TransitionsPersec bigint NULL ,
C2TransitionsPersec bigint NULL ,
C3TransitionsPersec bigint NULL ,
Caption varchar(100) NULL ,
Description varchar(100) NULL ,
DPCRate bigint NULL ,
DPCsQueuedPersec bigint NULL ,
Frequency_Object bigint NULL ,
Frequency_PerfTime bigint NULL ,
Frequency_Sys100NS bigint NULL ,
InterruptsPersec bigint NULL ,
Name varchar(100) NULL ,
PercentC1Time bigint NULL ,
PercentC2Time bigint NULL ,
PercentC3Time bigint NULL ,
PercentDPCTime bigint NULL ,
PercentIdleTime bigint NULL ,
PercentInterruptTime bigint NULL ,
PercentPrivilegedTime bigint NULL ,
PercentProcessorTime bigint NULL ,
PercentUserTime bigint NULL ,
Timestamp_Object bigint NULL ,
Timestamp_PerfTime bigint NULL ,
Timestamp_Sys100NS bigint NULL ,
datestamp datetime default getdate())

/****** Object: Table [dbo].[PerfRawData_PerfProc_Process] Script Date: 08/23/2008

03:29:25 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].
[PerfRawData_PerfProc_Process]') AND type in (N'U'))
DROP TABLE [dbo].PerfRawData_PerfProc_Process
GO
CREATE TABLE PerfRawData_PerfProc_Process(
Hostname varchar(100) NULL ,
___GENUS bigint NULL ,
___CLASS varchar(100) NULL ,
___SUPERCLASS varchar(100) NULL ,
___DYNASTY varchar(100) NULL ,
___RELPATH varchar(100) NULL ,
___PROPERTY_COUNT bigint NULL ,
___DERIVATION varchar(100) NULL ,