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
Configure the degree at which the aggregation process runs so that the Interact Event
Pattern report can render faster.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
to JOB_MA_3
.
- Set the value of
@p_parallel_degree
to 3
.
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
to JOB_C_3
.
- Set the value of
@p_parallel_degree
to 3
.
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
to JOB_WC_3
.
- Set the value of
@p_parallel_degree
to 3
.