Page History
...
Holds information on batch access plans.
| Column Name | Column Description |
|---|---|
SQEO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEO_DATABASE_NAME | Name of the database to which the statement belongs. |
SQEO_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. |
SQEO_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEO_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
SQEO_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEO_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEO_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEO_OPERATOR_TYPE | Physical operation in the access plan. |
SQEO_OPTIONS | Logical operation in the access plan. |
SQEO_EXECUTION_ORDER | Sequence order of this operation in the whole access plan. |
SQEO_TREE_LEVEL | Tree level of this operation in the access plan. |
SQEO_ARGUMENTS_LIST | Not in use. |
SQEO_REMOTE_STATEMENT_HV | Unique identifier (number) for the remote query used in this operation. |
SQEO_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEO_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEO_OBJ_NAME | Name of the object accessed in this operation. |
SQEO_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SQEO_TOTAL_SUBTREE_COST | Estimated cost of this operation and its descendants. |
SQEO_CONTRIBUTION_RATIO | Contribution value of the object in this operation to the statement. |
SQEO_ESTIMATE_COST | Estimated cost of this operation. |
SQEO_ESTIMATE_IO_COST | Estimated I/O cost of this operation. |
SQEO_ESTIMATE_CPU_COST | Estimated CPU cost of this operation. |
SQEO_ESTIMATE_ROWS | Estimated number of rows returned by this operation. |
SQEO_WARNINGS | Warnings in this operation. |
SQEO_PARALLEL_IND | Indicates if the operation is performed in parallel. |
SQEO_ESTIMATE_EXECUTION | Estimated number of times this operation is performed. |
SQEO_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SQEO_AVG_ROW_SIZE | Average row size this operation handles. |
PW_SQEH_EXPLN_HIST
Holds information on batch execution plans. Each batch can have up to three different execution plans.
| Column Name | Column Description |
|---|---|
SQEH_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEH_DATABASE_NAME | Database to which the statement belongs. |
SQEH_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. |
SQEH_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEH_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PW have the value 0. |
SQEH_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEH_TOTAL_ESTIMATE_COST | Estimated cost of the batch. |
SQEH_TOTAL_ESTIMATE_IO_COST | Estimated I/O cost of the batch. |
SQEH_TOTAL_ESTIMATE_CPU_COST | Estimated CPU cost of the batch. |
SQEH_TOTAL_ESTIMATE_ROWS | Estimated number of rows returned by the batch. Only rows from SELECT statements are calculated. |
SQEH_LAST_EXPLAIN_IND | Indicates that this access plan is the last access plan of the batch. |
SQEH_ACTUAL_PLAN_IND | An indicator if the execution plan is actual or estimated. |
PW_SQST_STATEMENTS_STATS_T
Stores statistics on statement and batch performance per timeslice.
| Info |
|---|
The _T table summarizes the data per timeslice. The _D table summarizes the data per day. The _W table summarizes the data per week. The _M table summarizes the data per month. |
| Column Name | Column Description |
|---|---|
SQST_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQST_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 |
SQST_PWHG_ID | Hour group ID. |
SQST_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQST_DATABASE_ID | Database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQST_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 |
SQST_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQST_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQST_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form). |
SQST_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the statement in its collapsed form. |
SQST_TOTAL_INMSSQL_TIME_SUM | Indicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns. |
SQST_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions which ended during the row's timeframe. |
SQST_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions which were still running at the end of the row's timeframe |
SQST_TOTAL_DURATION_SUM | Total amount of time SQL Server spent executing this statement. |
SQST_REQUEST_WAIT_SUM | Not in use in this table. |
SQST_CPU_SUM | Amount of time the process was actively executing a statement. |
SQST_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. |
SQST_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQST_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SQST_LOG_WAIT_SUM | Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a |
SQST_INTERNAL_WAIT_SUM | Amount of time the process was waiting for an internal resource to be freed. |
SQST_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SQST_PARALLEL_EXCHANGE_SUM | Amount of time the thread in a parallel session is waiting for data exchange from another thread. |
SQST_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SQST_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SQST_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SQST_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SQST_PARALLEL_DEGREE_MIN | Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. |
SQST_PARALLEL_DEGREE_MAX | Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. |
SQST_LOCK_ROW_SUM Amount of time the process was waiting to acquire a lock on a row.
SQST_LOCK_KEY_SUM Amount of time the process was waiting to acquire a lock on an index key or an index key range.
SQST_LOCK_PAGE_SUM Amount of time the process was waiting to acquire a lock on a table or index page.
SQST_LOCK_TABLE_SUM Amount of time the process was waiting to acquire a lock on a table.
SQST_COMPILE_LOCK_SUM Amount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure.
SQST_OTHER_LOCK_SUM Amount of time the process was waiting to acquire a lock on a process that is unrecognized by Precise for SQL Server.
SQST_RECIEVED_TIMESTAMP Local date and time the row was loaded into the PMDB.
SQST_SLA_RED_SUM Number of times the average amount of time SQL Server was actively executing the statement, exceeded the breach threshold for the type of program.
SQST_SLA_YELLOW_SUM Number of times the average amount of time SQL Server was actively executing the statement, exceeded the near-breach threshold for the type of program.
SQST_SLA_GREEN_SUM Number of times the average amount of time SQL Server was actively executing the statement, was below the near-breach threshold for the type of program.
SQST_ROWID Unique row number.
SQST_NET_IO_WAIT_SUM Groups all I/O related wait types.
SQST_TEMP_DB_WAIT_SUM Groups I/O / Latch on TempDB pages.
SQST_IDLE_WAIT_SUM This group includes the events indicating that a session is waiting for something other than a user request.
SQST_INTRNL_BP_WAIT_SUM This state groups the events, which all mean contention on pages in the buffer pool.
SQST_INTRNL_LATCH_WAIT_SUM This group includes all Latch related wait types.
SQST_INTRNL_PARALLEL_WAIT_SUM Amount of time the process was waiting for one of its sub-threads to complete its operation.
SQST_INTRNL_DTC_WAIT_SUM Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQST_INTRNL_DBMIRROR_WAIT_SUM Aggregates a couple of new waits that occur when DB Mirroring is used.
SQST_INTRNL_PROFILER_WAIT_SUM Aggregates a number of states associated with the Profiler.
SQST_INTRNL_MEMORY_WAIT_SUM Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQST_INTRNL_BACKUP_WAIT_SUM Includes write-ups commonly occurring when a session is doing a BACKUP command.
SQST_INTRNL_OTHER_WAIT_SUM This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
SQST_LOCK_MD_STAT_SUM Aggregates lock waits of the MetaData Statistics type.
SQST_LOCK_MD_PART_SUM Aggregates lock waits of the MetaData Partition Function type.
SQST_LOCK_MD_OTHER_SUM Aggregates lock waits of other MetaData types.
SQST_PC_RECOMPILATIONS_SUM Number of times this plan has been recompiled while it has remained in the cache.
SQST_PC_CACHE_EVICTIONS_SUM Number of times the plan has been evicted from the cache.
SQST_PC_EXECUTION_COUNT_SUM Number of times that the plan has been executed.
SQST_PC_TOTAL_WORKER_TIME_SUM Amount of CPU time that was consumed by executions of this plan.
SQST_PC_PHYSICAL_READS_SUM Number of physical reads performed by executions of this plan.
SQST_PC_LOGICAL_READS_SUM Number of logical reads performed by executions of this plan.
SQST_PC_LOGICAL_WRITES_SUM Number of logical writes performed by executions of this plan.
SQST_PC_CLR_TIME_SUM Time consumed inside CLR objects by executions of this plan.
SQST_PC_ELAPSED_TIME_SUM Total elapsed time for completed executions of this plan.