PerformanceCollector.IndexBlocking.sql 695 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
PRINT '-----------------------------------------------------------------------------------------------------------------'
PRINT '-- PerformanceCollector.IndexBlocking '
PRINT '-----------------------------------------------------------------------------------------------------------------'
IF OBJECT_ID('PerformanceCollector.IndexBlocking') IS NULL
BEGIN 
  Create table PerformanceCollector.IndexBlocking
  ( CurrTime datetime
  , ServerName varchar(200)
  , DbName varchar(200)
  , ObjDetails varchar(200)
  , Block_Waittime_ms bigint
  , index_id int
  , partition_number int
  )
END
ELSE BEGIN
	Print 'Table already exists, performing Alters (if required)...'
END
GO