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.
|Column name||Column type||Column constraint||Table constraints|
|logging_session_id||UNSIGNED INT||NOT NULL|
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.