sa_diagnostic_internalvariable table

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

Column name	Column type	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
request_id	UNSIGNED BIGINT	The ID of the request that contains the internal variable.
rowvariable_id	UNSIGNED INT	The column number in the row variable of this value.
variable_domain	UNSIGNED SMALLINT	The data type of the internal variable.
variable_name	CHAR(128)	The name of the internal variable.
variable_value	LONG NVARCHAR	A string representing the value of the internal variable.

sa_diagnostic_internalvariable table

Columns

See also