sa_diagnostic_auxiliary

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	Description
original_object_id	UNSIGNED BIGINT	The object ID of this object in the main tracing database.
local_object_id	UNSIGNED BIGINT	The object ID of this object in the auxiliary tracing database.
pages_if_table	UNSIGNED INT	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	UNSIGNED BIGINT	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.

sa_diagnostic_auxiliary_catalog table

Columns

See also