lyft_flush_plan_cache

Flushes the whole execution plan cache.

Syntax

lyft_flush_plan_cache [;]

Example

The following example flushes the in-memory execution plan.

exec lyft_flush_plan_cache;

lyft_run_garbage_collection

Attempts garbage collection to reclaim unused memory. May also clean up other resources like deleting temporary files.

Syntax

lyft_run_garbage_collection [;]

Example

The following example reclaims unused memory.

EXEC lyft_run_garbage_collection;

lyft_set_default_federator

Configures federator for an agent. Given connection will be new federator for given agent.

Syntax

lyft_set_default_federator 'connectionName', 'agentName' [;]

Arguments

'connectionName'

Name of connection that is to be new federator.

'agentName'

Name of existing Lyftron instance in the cluster for which to configure a new default federator. Those names can be found in Administer/Lyftron Instances.

Example

Sets federator for 'Root' agent to 'AdventureWorksDW_connection'.

EXEC lyft_set_default_federator @connectionName = 'AdventureWorksDW_connection', @agentName = 'Root';