Convert Perfmon clustered index based tables to clustered columnstore based tables

convert-perfmon-cci.sql

DECLARE	@pkname		sysname = (SELECT [name] FROM sys.key_constraints WHERE [type] = 'PK' AND parent_object_id = OBJECT_ID(N'dbo.CounterDetails'));
DECLARE	@sqlstmt	nvarchar(max) = N'ALTER TABLE dbo.CounterDetails DROP CONSTRAINT [' + @pkname + ']';
EXEC (@sqlstmt);

CREATE CLUSTERED COLUMNSTORE INDEX cci_CounterDetails ON dbo.CounterDetails
WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0, MAXDOP = 1);

--ALTER TABLE dbo.CounterDetails
--ADD CONSTRAINT PK_CounterDetails PRIMARY KEY NONCLUSTERED (CounterID);
GO

DECLARE	@pkname		sysname = (SELECT [name] FROM sys.key_constraints WHERE [type] = 'PK' AND parent_object_id = OBJECT_ID(N'dbo.CounterData'));
DECLARE	@sqlstmt	nvarchar(max) = N'ALTER TABLE dbo.CounterData DROP CONSTRAINT [' + @pkname + ']';
EXEC (@sqlstmt);

CREATE CLUSTERED COLUMNSTORE INDEX cci_CounterData ON dbo.CounterData
WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0, MAXDOP = 1);

--ALTER TABLE dbo.CounterData
--ADD CONSTRAINT PK_CounterData PRIMARY KEY NONCLUSTERED ([GUID], CounterID, RecordIndex);
GO