Changing the degree of parallel execution for the Interact Event Pattern report
The degree of parallel execution value is configurable. Increase the degree of parallel execution for the Interact Event Pattern report aggregation process to reduce the elapse time. If the degree is set to a higher value, hardware resource requirements also increase proportionally
About this task
To configure database jobs for a degree value of 3, complete one of the following steps, depending on your database:
Procedure
- For Oracle: Run the execute SP_POPULATE_PATTERN_LOCK(3) command against the Interact ETL database.
- For IBM® DB2®: Run the call SP_POPULATE_PATTERN_LOCK(3) command against the Interact ETL database.
-
For SQL Server: Run the default acir_jobs_sqlserver.sql script to create
database jobs for degree value 1 and 2. The patterns with degree values 1 and 2 are aggregated in
the
UARI_PROCESSED_PATTERNS
table.To modify the degree to 3 for the Match All Pattern, copy the sample code for degree 1 and complete the following steps:
- Set the value of
@job_name
toJOB_MA_3
. - Set the value of
@p_parallel_degree
to3
.
Run the following command against the Interact ETL database:
DECLARE @jobId BINARY(16), @status int, @schedule_name varchar(16), @dbname varchar(100) set @dbname= (SELECT DB_NAME()); EXEC msdb.dbo.sp_add_job @job_name=N'JOB_MA_3', @job_id = @jobId OUTPUT; EXEC msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'first', @command=N'EXEC [dbo].[SP_POPULATE_PATTERN_MATCHALL]@p_parallel_degree = 3', @database_name=@dbname; EXEC msdb.dbo.sp_add_jobserver @job_id=@jobId, @server_name=N'(local)'; GO
You can create the degree for the Counter Pattern and the Weighted Counter Pattern and run the commands against the ETL database.
To modify the degree to 3 for the Counter Pattern, copy the sample code for degree 1 and complete the following steps:
- Set the value of
@job_name
toJOB_C_3
. - Set the value of
@p_parallel_degree
to3
.
To modify the degree to 3 for the Weighted Counter Pattern, copy the sample code for degree 1 and complete the following steps:
- Set the value of
@job_name
toJOB_WC_3
. - Set the value of
@p_parallel_degree
to3
.
- Set the value of