Begin Transaction
Begin Try
Declare @collection_set_id_1 int
Declare @collection_set_uid_2 uniqueidentifier
EXEC [msdb].[dbo].[sp_syscollector_create_collection_set] @name=N'Server Activity SSAS Counters 1'
, @collection_mode=0
, @description=N'Collects top-level performance indicators for the computer and the Database Engine. Enables analysis of resource use, resource bottlenecks, and Database Engine activity.'
, @logging_level=0, @days_until_expiration=14
, @schedule_name=N'CollectorSchedule_Every_15min'
, @collection_set_id=@collection_set_id_1 OUTPUT
, @collection_set_uid=@collection_set_uid_2 OUTPUT
Select @collection_set_id_1, @collection_set_uid_2


Declare @collector_type_uid_5 uniqueidentifier
Select @collector_type_uid_5 = collector_type_uid From [msdb].[dbo].[syscollector_collector_types]
 Where name = N'Performance Counters Collector Type';
Declare @collection_item_id_6 int
EXEC [msdb].[dbo].[sp_syscollector_create_collection_item] @name=N'Server Activity - SSAS Performance Counters 1'
, @parameters=N'<ns:PerformanceCountersCollector xmlns:ns="DataCollectorType">
<PerformanceCounters Objects="Processor" Counters="%Processor Time" Instances="_Total" />
<PerformanceCounters Objects="Process" Counters="%Processor Time" Instances="msmdsrv" />
<PerformanceCounters Objects="Process" Counters="%Processor Time" Instances="sqlservr" />
<PerformanceCounters Objects="MSAS 2008:Connection" Counters="Current connections" />
<PerformanceCounters Objects="MSAS 2008:Connection" Counters="Current user sessions" />
<PerformanceCounters Objects="MSAS 2008:Memory" Counters="Memory Usage KB" />
<PerformanceCounters Objects="MSAS 2008:Storage Engine Query" Counters="Current measure group queries" />
<PerformanceCounters Objects="MSAS 2008:Storage Engine Query" Counters="Avg time/query" />
<PerformanceCounters Objects="MSAS 2008:Storage Engine Query" Counters="Aggregation hits/sec" />
<PerformanceCounters Objects="MSAS 2008:Storage Engine Query" Counters="Queries answered/sec" />
<PerformanceCounters Objects="MSAS 2008:Storage Engine Query" Counters="Total queries answered" />
<PerformanceCounters Objects="MSAS 2008:MDX" Counters="Total cells calculated" />
</ns:PerformanceCountersCollector>'
, @collection_item_id=@collection_item_id_6 OUTPUT, @frequency=60
, @collection_set_id=@collection_set_id_1, @collector_type_uid=@collector_type_uid_5
Select @collection_item_id_6

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