use msdb;
Begin Transaction
Begin Try
Declare @collection_set_id_23 int
Declare @collection_set_uid_24 uniqueidentifier
EXEC [dbo].[sp_syscollector_create_collection_set] @name=N'Query Statistics', @collection_mode=0, @description=N'Collects query statistics, T-SQL text, and query plans of most of the statements that affect performance. Enables analysis of poor performing queries in relation to overall SQL Server Database Engine activity.', @target=N'', @logging_level=1, @days_until_expiration=14, @proxy_name=N'', @schedule_name=N'CollectorSchedule_Every_15min', @collection_set_id=@collection_set_id_23 OUTPUT, @collection_set_uid=@collection_set_uid_24 OUTPUT
Select @collection_set_id_23, @collection_set_uid_24

Declare @collector_type_uid_25 uniqueidentifier
Select @collector_type_uid_25 = collector_type_uid From [dbo].[syscollector_collector_types] Where name = N'Query Activity Collector Type';
Declare @collection_item_id_26 int
EXEC [dbo].[sp_syscollector_create_collection_item] @name=N'Query Statistics - Query Activity', @parameters=N'', @collection_item_id=@collection_item_id_26 OUTPUT, @frequency=10, @collection_set_id=@collection_set_id_23, @collector_type_uid=@collector_type_uid_25
Select @collection_item_id_26

Commit Transaction;
End Try
Begin Catch
Rollback Transaction;
DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
DECLARE @ErrorState INT;
DECLARE @ErrorNumber INT;
DECLARE @ErrorLine INT;
DECLARE @ErrorProcedure NVARCHAR(200);
SELECT @ErrorLine = ERROR_LINE(),
       @ErrorSeverity = ERROR_SEVERITY(),
       @ErrorState = ERROR_STATE(),
       @ErrorNumber = ERROR_NUMBER(),
       @ErrorMessage = ERROR_MESSAGE(),
       @ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-');
RAISERROR (14684, @ErrorSeverity, 1 , @ErrorNumber, @ErrorSeverity, @ErrorState, @ErrorProcedure, @ErrorLine, @ErrorMessage);

End Catch;

GO