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