SQL Server Data Collector performance_counter_instances fix

ALTER DATABASE DataCollectorWarehouse SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DROP INDEX [IDX_performance_counter_instances1] ON [snapshots].[performance_counter_instances]
ALTER TABLE [snapshots].[performance_counter_instances] DROP CONSTRAINT [UN_performance_counter_path]
ALTER TABLE [snapshots].[performance_counter_instances] DROP CONSTRAINT [PK_performance_counter_instances]
GO
ALTER TABLE [snapshots].[performance_counter_instances] ALTER COLUMN [performance_counter_id] [bigint] NOT NULL
GO
ALTER TABLE [snapshots].[performance_counter_instances] ADD CONSTRAINT [PK_performance_counter_instances] PRIMARY KEY CLUSTERED  ([performance_counter_id]) ON [PRIMARY]
ALTER TABLE [snapshots].[performance_counter_instances] ADD CONSTRAINT [UN_performance_counter_path] UNIQUE NONCLUSTERED  ([path]) WITH (IGNORE_DUP_KEY=ON) ON [PRIMARY]
CREATE NONCLUSTERED INDEX [IDX_performance_counter_instances1] ON [snapshots].[performance_counter_instances] ([object_name], [counter_name]) ON [PRIMARY]
GO
ALTER DATABASE DataCollectorWarehouse SET MULTI_USER
GO