|
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.
| 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.