-- Table: dbo.DbPerfHistory
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[DbPerfHistory] (
	[DbName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SampleDate] [datetime] NOT NULL ,
	[DataFileSize_KB] [int] NULL ,
	[LogFileSize_KB] [int] NULL ,
	[LogFileSizeUsed_KB] [int] NULL ,
	[FirstTranRateSample] [int] NULL ,
	[LastTranRateSample] [int] NULL ,
	[CurTxnPerSec] [numeric](16, 6) NULL ,
	[MinTxnPerSec] [numeric](16, 6) NULL ,
	[MinTxnDt] [datetime] NULL ,
	[MaxTxnPerSec] [numeric](16, 6) NULL ,
	[MaxTxnDt] [datetime] NULL ,
	[TransActivityDetected] [int] NULL ,
	[FirstSampleDt] [datetime] NULL ,
	[LastSampleDt] [datetime] NULL ,
	CONSTRAINT [pk_DbPerfHistory__SampleDate__DbName] PRIMARY KEY  CLUSTERED 
	(
		[SampleDate],
		[DbName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO