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

___SERVER varchar(100) NULL ,
___NAMESPACE varchar(100) NULL ,
___PATH varchar(100) NULL ,
AvgDiskBytesPerRead bigint NULL ,
AvgDiskBytesPerRead_Base bigint NULL ,
AvgDiskBytesPerTransfer bigint NULL ,
AvgDiskBytesPerTransfer_Base bigint NULL ,
AvgDiskBytesPerWrite bigint NULL ,
AvgDiskBytesPerWrite_Base bigint NULL ,
AvgDiskQueueLength bigint NULL ,
AvgDiskReadQueueLength bigint NULL ,
AvgDisksecPerRead bigint NULL ,
AvgDisksecPerRead_Base bigint NULL ,
AvgDisksecPerTransfer bigint NULL ,
AvgDisksecPerTransfer_Base bigint NULL ,
AvgDisksecPerWrite bigint NULL ,
AvgDisksecPerWrite_Base bigint NULL ,
AvgDiskWriteQueueLength bigint NULL ,
Caption varchar(100) NULL ,
CurrentDiskQueueLength bigint NULL ,
Description varchar(100) NULL ,
DiskBytesPersec bigint NULL ,
DiskReadBytesPersec bigint NULL ,
DiskReadsPersec bigint NULL ,
DiskTransfersPersec bigint NULL ,
DiskWriteBytesPersec bigint NULL ,
DiskWritesPersec bigint NULL ,
Frequency_Object bigint NULL ,
Frequency_PerfTime bigint NULL ,
Frequency_Sys100NS bigint NULL ,
Name varchar(100) NULL ,
PercentDiskReadTime bigint NULL ,
PercentDiskTime bigint NULL ,
PercentDiskWriteTime bigint NULL ,
PercentIdleTime bigint NULL ,
SplitIOPerSec bigint NULL ,
Timestamp_Object bigint NULL ,
Timestamp_PerfTime bigint NULL ,
Timestamp_Sys100NS bigint NULL ,
datestamp datetime default getdate())
/****** Object: Table [dbo].[PerfRawData_PerfOS_Memory]

Script Date: 08/23/2008

03:29:25 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].
[PerfRawData_PerfOS_Memory]') AND type in (N'U'))
DROP TABLE [dbo].PerfRawData_PerfOS_Memory
GO

CREATE TABLE PerfRawData_PerfOS_Memory(
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 ,