workload_metric

Description

Cluster environments only – Queries the current workload metric for the instance you specify, or updates the metric for the instance you specify.

Syntax

workload_metric( instance_id | instance_name [, new_value ] )

Parameters

instance_id

ID of the instance.

instance_name

name of the instance.

new_value

float value representing the new metric.

Examples

Example 1

Sees the user metric on the current instance:

select workload_metric()

Example 2

Sees the user metric on instance “ase2”:

select workload_metric("ase2")

Example 3

Sets the value of the user metric on “ase3” to 27.54:

select workload_metric("ase3", 27.54)

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

You must have the sa_role or ha_role to execute workload_metric