sa_diagnostic_auxiliary_catalog table

The sa_diagnostic_auxiliary_catalog table is owned by the dbo user, and is used to map database objects between the production database and tracing database. Objects include user tables, procedures, and functions. This table is used primarily by the Index Consultant and the TRACED_PLAN function.

Columns
Column name Column type Column constraint Table constraints
original_object_id UNSIGNED BIGINT NOT NULL Primary key.
local_object_id UNSIGNED BIGINT NOT NULL Unique.
pages_if_table UNSIGNED INT
rows_if_table UNSIGNED BIGINT

original_object_id   The object ID of this object in the main tracing database.

local_object_id   The object ID of this object in the auxiliary tracing database.

pages_if_table   If the object is a table, this is the number of pages in the table. If the object is not a table, this value is NULL.

rows_if_table   If the object is a table, this is the number of rows in the table. If the object is not a table, this value is NULL.

See also