The sa_diagnostic_internalvariable table is owned by the dbo user, and contains the values of internal (local) variables used by a given statement. This table is primarily used by the Index Consultant, and the traced_plan function.

There are two versions of this table: sa_diagnostic_internalvariable, and sa_tmp_diagnostic_internalvariable.

Columns

logging_session_id   A number uniquely identifying the logging session during which the diagnostic information was gathered.

request_id   The ID of the request that contains the internal variable.

rowvariable_id   The column number in the row variable of this value.

variable_domain   The data type of the internal variable.

variable_name   The name of the internal variable.

variable_value   A string representing the value of the internal variable.

See also

• Local variables