Skip to main content

EXECUTE.TASK

Ute Gillet
  • Updated

Command to execute 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

FromNot supported
ToTask log

 

Parameters

@Task

The task to execute: ContentStoreSync, RebuildIndices, UpdateStatistics

@LogLevel

The log level for the output can be set to one of the following:
Verbose, Debug, Information, Warning, Error, Fatal. The default log level is: Information

 

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.

Related articles

Comments

0 comments

Please sign in to leave a comment.