Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Old Version 55

changes.mady.by.user Nadja Pollard

Saved on Feb 16, 2021

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on Feb 17, 2021

Key

This line was added.
This line was removed.
Formatting was changed.

...

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 `PW_SQUN_USER_NAMES_N`.
`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: 1: Heavy Statement 2: Heavy Object 3: Heavy Collapsed Statement 4: Instance event
`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.

PW_SQPU_PARTITION_USAGE_D

Collects space information per partition.

Column Name	Column Description
`SQPU_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQPU_OBJECT_ID`	ID of the object.
`SQPU_FULL_OBJECT_ID`	The full object ID, normalized in table `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQPU_INDEX_ID`	ID of the index.
`SQPU_PARTITION_ID`	ID of the partition.
`SQPU_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQPU_PWHG_ID` should be used.
`SQPU_PWHG_ID`	Hour group ID.
`SQPU_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row (in minutes).
`SQPU_P_ALL_ALLOC_MAX`	Number of allocated pages for a specific partition (in MB).
`SQPU_P_ALL_USED_MAX`	Number of used pages for a specific partition (in MB).
`SQPU_ROW_COUNT_MAX`	Number of rows on a specific partition
`SQPU_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.

PW_SQCP_SCHEMA_CHANGES_PS

Collects information about schema changes made to a partition schema.

Column Name	Column Description
`SQCP_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQCP_NAME`	Name of the partition schema.
`SQCP_ID`	Partition schema ID.
`SQCP_NUMBER_FG`	Number of file groups of the partition schema.

PW_SQCF_SCHEMA_CHANGES_PS_FG

Collects information about schema changes made to a partition schema filegroup.

Column Name	Column Description
`SQCF_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQCF_PS_NAME`	Name of the partition schema.
`SQCF_FP_NAME`	Name of the partition function.
`SQCF_PS_TYPE`	Type of the partition schema.

PW_SQCN_SCHEMA_CHANGES_PF

Collects information about schema changes made to a partition function.

Column Name	Column Description
`SQCN_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQCN_PF_NAME`	Name of the partition function.
`SQCN_NUM_VALUES`	Number of values of the partition function.
`SQCN_PF_TYPE`	Partition function type.

PW_SQCV_SCHEMA_CHANGES_PF_VAL

Collects information about schema changes made to a partition function values.

Column Name	Column Description
`SQCV_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQCV_PF_NAME`	Name of the partition function.
`SQCV_VALUE`	Value of the partition function, one row for each value.
`SQCV_POSITION`	Position of the value within the partition function.
`SQCV_TYPE`	Type of the value, such as int and date.

PW_SQWI_WAIT_INFO

Contains wait event counters info (MS-SQL).

Column Name	Column Description
`SQWI_WAIT_GROUP`	Normalized, wait group names.
`SQWI_WAIT_TYPE`	Normalized, wait type names.
`SQWI_GROUP_FROM_VERSION`	Group from, based on MS-SQL version.
`SQWI_GROUP_TILL_VERSION`	Group till, based on MS-SQL version.
`SQWI_COUNTER_FROM_VERSION`	Counter from, based on MS-SQL version.
`SQWI_COUNTER_TILL_VERSION`	Counter till, based on MS-SQL version.
`SQWI_EXPLANATION`	Counter explanation.
`SQWI_IS_LATCH`	Wait event - 0. Latch event - 1.

PW_SQWC_WAIT_COUNTERS_T

Contains wait counter’s data (MS-SQL).

Column Name	Column Description
`SQWC_WAIT_TYPE`	Wait type ID.
`SQWC_WAITING_TASKS_COUNT_SUM`	Wait event's counter.
`SQWC_TOTAL_WAIT_TIME_SUM`	Summarizes wait event's total wait time.
`SQWC_RESOURCE_WAIT_TIME_SUM`	Summarizes wait event's resource wait time.

PW_SQOP_OBJECTS_PERFORMENCE_D

A daily table which is being loaded every night by the Collects objects PMDB process. The table summarizes statistic data (such as locks, in_msssql, and using_cpu) per object (such as table and index). The idea behind this table is to accelerate the GUI in the Objects workspace.

Column Name	Column Description
`SQOP_PWII_INSTANCE_ID`	ID of the MS-SQL Server instance.
`SQOP_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQAM_PWHG_ID` should be used.
`SQOP_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQOP_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQOP_PWHG_ID`	Hour group ID.
`SQOP_OBJECT_FULL_ID`	For heavy object finding, the Ignored table ID, Normalized in table `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQOP_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
FULL_TABLE_ID	Full table ID means: `<db_name>,<table_owner>,<table_name>`. It is a normalized field which holds only a numeric hash value of the full table name. The normalization table is: `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQOP_TOTAL_INMSSQL_SUM`	Indicates the total amount of time MS-SQL Server was actively executing queries. It is also the sum of the columns.
`SQOP_USING_CPU_SUM`	Total time of CPU use.
`SQOP_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQOP_LOCK_ROW_SUM`	Aggregates lock waits of row locks.
`SQOP_LOCK_KEY_SUM`	Aggregates lock waits of key locks.
`SQOP_LOCK_PAGE_SUM`	Aggregates lock waits of page locks.
`SQOP_LOCK_TABLE_SUM`	Aggregates lock waits of table locks.
`SQOP_LOCK_OTHER_SUM`	Aggregates lock waits of other locks.
`SQOP_LOCK_MD_STAT_SUM`	Aggregates lock waits of MetaData Statistics type.
`SQOP_LOCK_MD_PART_SUM`	Aggregates lock waits of MetaData Partition Function type.
`SQOP_LOCK_MD_OTHER_SUM`	Aggregates lock waits of other MetaData types.

PW_SQEE_EXPLN_ESTIMATED_COST

Contains overtime history of statement's estimated cost changes.

Column Name	Column Description
`SQEE_PWII_INSTANCE_ID`	ID of the MS-SQL Server instance.
`SQEE_DATABASE_NAME`	Name of the database.
`SQEE_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.
`SQEE_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEE_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
`SQEE_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEE_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEE_ESTIMATE_COST`	Estimated cost of this operation.
`SQEE_ACTUAL_PLAN_IND`	An indicator if the execution plan is actual or estimated `PW_SQEA_EXPLN_ACCESS_PATH`.

PW_SQEA_EXPLN_ACCESS_PATH

Contains overtime history of statement's access path changes.

Column Name	Column Description
`SQEA_PWII_INSTANCE_ID`	ID of the MS-SQL Server instance.
`SQEA_DATABASE_NAME`	Name of the database.
`SQEA_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.
`SQEA_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEA_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
`SQEA_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEA_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEA_ESTIMATE_COST`	Estimated cost of this operation.
`SQEA_ACTUAL_PLAN`	An indicator if the execution plan is actual or estimated.
`SQEA_ACCESS_PATH_HV`	Unique identifier (number) assigned to the access plan of the statement.
`SQEA_MISS_INDEXES_IMPACT`	The minimal possible impact of indexes that are missing for effective query execution.
`SQEA_EXPLAIN_OPER_USAGE`	This column contains a mask of operations that appeared in the execution plan.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools