PRINT '-----------------------------------------------------------------------------------------------------------------'
PRINT '-- PerformanceCollector.PlanCacheMetrics '
PRINT '-----------------------------------------------------------------------------------------------------------------'
IF OBJECT_ID('PerformanceCollector.PlanCacheMetrics') IS NULL
BEGIN 
  Create table PerformanceCollector.PlanCacheMetrics
  ( CurrTime datetime
  , ServerName varchar(200)
  , DBName varchar(200)
  , SPName varchar(200)
  , ExecutionCount bigint
  , CallsPerSecond bigint
  , TotalWorkerTime bigint
  , TotalElapsedTime bigint
  , AvgElapsedTime bigint
  , AvgWorkerTime bigint
  , TotalLogicalReads bigint
  , AvgLogicalReads bigint
  , TotalPhysicalReads bigint
  , AvgPhysicalReads bigint
  , TotalLogicalWrites bigint
  , AvgLogicalWrites bigint
  , CachedTime datetime
  , RowNumber int
  , Metric varchar(200)
  )
END
ELSE BEGIN
	Print 'Table already exists, performing Alters (if required)...'
END
GO