Page History
...
| 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_RECEIVED_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. |
PW_SQSS_SESSIONS_STATS_T
Stores application performance statistics per timeslice for every combination of instance, database, program, user, logon, machine, and work type.
| 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 |
|---|---|
SQSS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQSS_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 |
SQSS_PWHG_ID | Hour group ID. |
SQSS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQSS_PROGRAM_ID | ID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N. |
SQSS_DATABASE_ID | ID of the database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQSS_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 |
SQSS_LOGIN_ID | The name used to log in to the database. In case of Windows Authentication mode, it contains the domain and the Windows NT user name, normalized in table |
SQSS_MACHINE_ID | The ID of the client workstation, normalized in table PW_SQMN_MACHINE_NAMES_N. |
SQSS_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SQSS_ERP_IDENTIFIER1_ID | ID of the ERP entity, normalized in table PW_SQE1_ERP_IDENTIFIERS1_N. |
SQSS_ERP_IDENTIFIER2_ID | ID of the ERP entity, normalized in table PW_SQE2_ERP_IDENTIFIERS2_N. |
SQSS_ERP_IDENTIFIER3_ID | ID of the ERP entity, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N. |
SQSS_ERP_IDENTIFIER4_ID | ID of the ERP entity, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N. |
SQSS_TOTAL_INMSSQL_TIME_SUM | Total amount of time SQL Server was actively executing queries. It is also the sum of the columns. |
SQSS_TOTAL_DURATION_SUM | Total amount of time SQL Server spent executing this session. |
SQSS_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SQSS_CPU_SUM | Amount of time the process was actively executing a statement. |
SQSS_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. |
SQSS_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQSS_REMOTE_WAIT_SUM | Amount of time the process was waiting for remote query to terminate. |
SQSS_LOG_WAIT_SUM | Amount of time the process was waiting on an operation on the log file to terminate. This state is generally encountered during a COMMIT or ROLLBACK operation. |
SQSS_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SQSS_INTERNAL_WAIT_SUM | Amount of time the process was waiting for an internal resource to be freed. |
SQSS_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SQSS_PARALLEL_WAIT_SUM | Amount of time the process was waiting for one of its sub-threads to complete its operation. |
SQSS_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SQSS_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SQSS_PARALLEL_EXCHANGE_SUM | Amount of time the thread in a parallel session is waiting for data exchange from another thread. |
SQSS_NUM_OF_ENDED_SESSIONS | Number of sessions, which ended during the row's timeframe. |
SQSS_NUM_OF_SESSIONS_NOT_ENDED | Number of sessions, which were still open at the end of the row's timeframe. |
SQSS_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SQSS_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SQSS_STAT_CPU_SUM | Statistics summing the amount of the process's read memory usage. |
SQSS_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SQSS_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SQSS_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SQSS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQSS_LOCKED_ROW_SUM | Amount of time the process was waiting to acquire a lock on a row. |
SQSS_LOCKED_KEY_SUM | Amount of time the process was waiting to acquire a lock on an index key or an index key range. |
SQSS_LOCKED_PAGE_SUM | Amount of time the process was waiting to acquire a lock on a table or index page. |
SQSS_LOCKED_TABLE_SUM | Amount of time the process was waiting to acquire a lock on a table. |
SQSS_OTHER_LOCK_SUM Amount of time the process was waiting to acquire a lock that is unrecognized by Precise for SQL Server.
SQSS_SLA_RED_SUM Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Breach threshold for the type of program.
SQSS_SLA_YELLOW_SUM Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Near-Breach threshold for the type of program.
SQSS_SLA_GREEN_SUM Number of times the average amount of time SQL Server was actively executing the session's statement, was below Near-Breach threshold for the type of program.
SQSS_ROWID Unique row number.
SQSS_TOTAL_INMSSQL_SUM Indicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
SQSS_TOTAL_DURATION_SUM Total amount of time SQL Server spent executing this statement.
SQSS_REQUEST_WAIT_SUM Not in use in this table.
SQSS_USING_CPU_SUM Total time of CPU use.
SQSS_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.
SQSS_IO_WAIT_SUM Amount of time the process was waiting for I/O operations to terminate.
SQSS_REMOTE_WAIT_SUM Amount of time the process was waiting for a remote query to terminate.
SQSS_LOCK_MD_OTHER_SUM Total time that session waited on Meta Data Lock type.
SQSS_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.
SQSS_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.
SQSS_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.
SQSS_PC_RECOMPILATIONS_SUM Number of times this plan has been recompiled while it has remained in the cache.
SQSS_PC_CACHE_EVICTIONS_SUM Number of times the plan has been evicted from the cache.
SQSS_PC_EXECUTION_COUNT_SUM Number of times that the plan has been executed
SQSS_PC_TOTAL_WORKER_TIME_SUM Amount of CPU time that was consumed by executions of this plan.
SQSS_PC_PHYSICAL_READS_SUM Number of physical reads performed by executions of this plan.
SQSS_PC_LOGICAL_READS_SUM Number of logical reads performed by executions of this plan.
SQSS_PC_LOGICAL_WRITES_SUM Number of logical writes performed by executions of this plan.
SQSS_PC_CLR_TIME_SUM Time consumed inside CLR objects by executions of this plan.
SQSS_PC_ELAPSED_TIME_SUM Total elapsed time for completed executions of this plan.