Page History
...
Holds information on the SQL Server instance MTNC change log.
| Column Name | Column Description |
|---|---|
SQCH_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCH_ENTITY_TYPE | Type of the entity that was changed. |
SQCH_ENTITY_NAME | Name of the entity that was changed. |
SQCH_PARENT_ENTITY_NAME | The name of the parent entity that was changed. |
SQCH_CHANGE_TYPE | Type of the performed change (Created, Dropped, Updated). |
SQCH_DATA_CHANGED | Name of the property that was changed. |
SQCH_OLD_VALUE | Old value, before the change. |
SQCH_NEW_VALUE | New value, after the change. |
SQCH_SAMPLE_DATE | Sample time. |
PW_SQEC_EXPLN_COLUMN
Holds information on the statement execution plan.
| Column Name | Column Description |
|---|---|
SQEC_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEC_DATABASE_NAME | Name of the database in which the change occurred. |
SQEC_PARSING_USER | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SQEC_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEC_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PW have the value. |
SQEC_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEC_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEC_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEC_PREDICATE_ID | Sequent of the predicate. |
SQEC_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEC_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEC_OBJ_NAME | Name of the object accessed in this operation. |
SQEC_OBJ_NAME_ALIAS | Alias of the object accessed in this operation. |
SQEC_COLUMN_NAME | Name of the column of the object that was changed. |
SQEC_USED_IN_SEEK | Indicates whether the column in the specified operator is used in a seek action. The value can be Y/N. |
SQEC_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SQEC_UNION_ID | The Union ID to which the column belongs (starting from 0) when the statement contains union. |
PW_SQBX_BATCH_TEXT
Holds the text of batches.
| Column Name | Column Description |
|---|---|
SQBX_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQBX_BATCH_TEXT | The text of the batch. |
PW_SQIF_IGNORE_FINDINGS
Holds the list of SmarTune findings that will not be displayed in the SmarTune workspace if the user marked them to be ignored.
| Column Name | Column Description |
|---|---|
SQIF_STATEMENT_HV | For the heavy collapsed statement, it contains the collapsed hash value. |
SQIF_DATABASE_ID | For the heavy statement and heavy collapsed statement types, this is the database ID at which the statement was running, normalized at PW_SQDN_DATABASE_NAMES_N. |
SQIF_DATABASE_NAME | For the heavy statement and heavy collapsed statement types, this is the database name on which the statement was running. For the heavy object finding type, it is the table's database name. |
SQIF_USER_ID | One of the MS-SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table |
SQIF_USER_NAME | For the heavy statement and heavy collapsed statements, this is the user that runs the statement. For the heavy object finding, this is the owner of the table. |
SQIF_FULL_OBJECT_ID | For the heavy object finding, this is the Ignored table ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
SQIF_FINDING_TYPE | The type of the finding:
|
SQIF_UI_USER_NAME | This is the user (login) that asked the finding to be ignored. |
SQIF_INSTANCE_PROBLEM_ID | For the Instance event finding, it contains the instance event ID. |
PW_SQEJ_EXPLN_OPER_OBJECTS
Holds all the object operators per object.
| Column Name | Column Description |
|---|---|
SQEJ_DATABASE_NAME | Name of the database. |
SQEJ_PARSING_USER | One of the MS-SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SQEJ_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SQEJ_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB get this the value. |
SQEJ_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEJ_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEJ_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEJ_OPERATOR_TYPE | Physical operation in the access plan. |
SQEJ_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEJ_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEJ_OBJ_NAME | Name of the object accessed in this operation. |
SQEJ_OBJ_NAME_ALIAS | Alias name of the object accessed in this operation. |
SQEJ_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SQEJ_CONTRIBUTION_RATIO | Contribution value of the object in this operation to the statement. |
SQEJ_MISS_INDEXES_IND | Indicator if indexes are missing in this operation. |