Page History
...
Info |
---|
The The The The |
Column Name | Column Description |
---|---|
SQLO_PWII_INSTANCE | ID of the SQL Server instance. |
SQLO_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 SQLO_PWHG_ID should be used. |
SQLO_PWHG_ID | Hour group ID. |
SQLO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLO_DATABASE_ID | ID of the database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQLO_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SQLO_LOCKED_OBJECT_TYPE | Type of object being locked, such as table and file. |
SQLO_LOCKED_OBJECT_ID | The ID of the locked object, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N . |
| These three columns combine together the locked object's identifier in SQL Server. For example: a locked index is represented by:
|
SQLO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLO_ROWID | Unique row number. |
PW_SQSM_STATEMENTS
Holds statements collected by the Precise for SQL Server collector and statements inserted through the statement workshop (SQL workspace). The table holds one row per statement and connects it to the first batch in which the statement was sampled. You can join the statement with other batches run, but only for statistics tables. (PW_SQST_STATEMENTS_STATS
or PW_STSE_SESS_STATEMENTS_STATS
).
Column Name | Column Description |
---|---|
SQSM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQSM_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQSM_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SQSM_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the statement in its collapsed form. |
SQSM_COLLAPSED_STATEMENT_ID | Unique identifier (string) assigned to the statement in its collapsed form. |
SQSM_INSERT_TIME | Date and time the statement was saved in the database. |
SQSM_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. |
SQSM_PARSING_USER_ID | 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, normalized in table PW_SQUN_USE_NAMES_N . |
SQSM_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the SQL workspace. |
SQSM_SOURCE | Indicates how the statement was loaded. Possible values:
|
SQSM_LAST_EXPLAINED | Last time the statement was explained. |
SQSM_TOTAL_MSSQL_TIME | Not in use. |
SQSM_DO_NOT_EXPLAIN | Indicates an error during the explain of the statement. If |
SQSM_EXPLAIN_ERROR_MSG | Error that occurred during the last explain process. |
SQSM_LAST_ACC_PATH_CHANGED | Last time the access plan of the statement changed. |
SQSM_ACCESS_PATH_HV | Unique identifier (number) assigned to the access plan of the statement. |
SQSM_TOTAL_ESTIMATED_COST | Estimated cost of the statement’s execution. A high cost value may indicate a problem in the current implementation of the statement. To determine which operation may have caused the problem, you can use the Estimated Cost Breakdown graph to drill down easily and see the most resource consuming operation. To determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both), check the Estimated I/O cost and Estimated CPU cost values. |
SQSM_DATABASE_NAME | Name of the database to which the statement belongs. |
SQSM_DATABASE_ID | ID of the database, in which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQSM_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SQSM_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SQSM_STATEMENT_OFFSET | The offset of the statement in the first batch sampled, running the statement by the Collector agent. |
SQSM_STATEMENT_LENGTH | Length of the statement in the first batch sampled running the statement. |
SQSM_STATEMENT_ID_IN_BATCH | Statement number in the first batch sampled running the statement. |
SQSM_START_EXEC_ORDER_IN_BATCH | Execution order the statement started with in the access plan of the batch. |
SQSM_START_TREE_LEVEL | Start level of the statement in the access plan of the batch. |
SQSM_EXPLAIN_USAGE_MAP | Internal bit representative of the types of the operators in the execution plan. |
SQSM_ACTUAL_PLAN_IND | MS-SQL 2005 only. Indication if the last execution plan of the statement is Actual or estimate. |
SQSM_MISS_INDEXES_IMPACT | MS-SQL 2005 only. Indication if the last execution plan of the statement has missing indexes indication. |
SQSM_STATEMENT_TYPE | Representing the type of the statement. Such as INSERT and SELECT . |