EXECUTE.TASK

  • Updated

Command to execute tasks from the Schedular e.g. system maintenance tasks such as rebuilding database indexes, updating database statistics, and synchronizing the content store. This command is particularly useful after performing several large imports. These tasks can also be scheduled through the Scheduler for regular database maintenance.

Properties

From Not supported
To Not supported

 

Parameters

@Task

The task name usen in the Scheduler. It require the name is unique in the Scheduler.

@LogLevel
  • True (default): The action starts the Task and will only proceed to the next steps once the Task has completed. If the Task fails, the action will also fail.
  • False: The action starts the Task asynchronously and immediately continues to the next steps without waiting for the Task to finish. If the Task fails, the action will continue and will not fail.

 

Parameters for Rebuild Database Indices

@ReorganizeFragmentationPercentage

Reorganize index when fragmentation is above: Specify the fragmentation threshold at which an index should be reorganized.

  • Default: 10% or higher.

  • If fragmentation is below or above the rebuild threshold, no action will be taken for that index or table.

  • If fragmentation occurs, reorganization will not occur because the index/table is scheduled for a rebuild instead.

@RebuildFragmentationPercentage

Rebuild index when fragmentation is above: Specify the fragmentation threshold at which an index or table should be rebuilt instead of reorganized.

  • Default: 30% or higher.

  • If fragmentation is below this percentage, no rebuild will occur

@LeastPageCount

Least page count in INDEX to rebuild/reorganize: Define the minimum number of pages an index or table must occupy before it can be rebuilt or reorganized. A table or index might be highly fragmented, but if it is very small, the impact on performance is negligible. Default: 10 pages.

Note: In SQL Server, one page equals 8 KB of data.
@ReworkIndexCommandTimeout

Command Timeout (per index handled): Set the maximum amount of time SQL Server is allowed to spend on processing each table or index during the task. We recommend 3600 seconds (1 hour), which is typically sufficient for most operations.

 

Parameters for Update Database Statistics

@SamplePercentage

Update statistics with row sample percentage: Specify the percentage of sample data SQL Server should use from each table and index to calculate statistics. Default is 80%.

@UpdateStatsCommandTimeout

Command Timeout (per index updated): Updating statistics on a single index or table is usually quick (a few seconds). However, Perfion contains some tables that can grow very large, requiring more time to update their statistics. Default is 3600 seconds (1 hour). This timeout ensures that even large tables have sufficient time to complete the update process.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.