-- Table: dbo.SrvPerfHistory
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[SrvPerfHistory] (
	[SampleDate] [datetime] NOT NULL ,
	[TableScans] [numeric](16, 6) NULL ,
	[BatchRequestPerSec] [numeric](16, 6) NULL ,
	[DataCacheHitRatio] [numeric](12, 2) NULL ,
	[DataCacheHitRatioBase] [numeric](12, 2) NULL ,
	[ProcCacheHitRatio] [numeric](12, 2) NULL ,
	[ProcCacheHitRatioBase] [numeric](12, 2) NULL ,
	CONSTRAINT [pk_SrvPerfHistory__SampleDate] 
        PRIMARY KEY  CLUSTERED 
	(
		[SampleDate]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO