Page History
...
Stores statistics on statement and batch performance per timeslice.
Info |
---|
The The The The The The The The |
...
Stores application performance statistics per timeslice for every combination of instance, database, program, user, logon, machine, and work type.
Info |
---|
The The The The The The |
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_EVICTION_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. |
PW_SQSE_SESSIONS_STMT_STATS_T
Stores statistics about performance on every combination of statements and session identifiers, such as instance, database, program, user, logon, machine, and work type per timeslice.
Info |
---|
The The The The |
Column Name | Column Description |
---|---|
SQSE_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQSE_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 SQSE_PWHG_ID should be used. |
SQSE_PWHG_ID | Hour group ID. |
SQSE_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQSE_PROGRAM_ID | ID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N . |
SQSE_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQSE_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 |
SQSE_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 |
SQSE_MACHINE_ID | The ID of the client workstation, normalized in table PW_SQMN_MACHINE_NAMES_N . |
SQSE_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SQSE_ERP_IDENTIFIER1_ID | ID of the ERP entity, normalized in table PW_SQE1_ERP_IDENTIFIERS1_N. |
SQSE_ERP_IDENTIFIER2_ID | ID of the ERP entity, normalized in table PW_SQE2_ERP_IDENTIFIERS2_N. |
SQSE_ERP_IDENTIFIER3_ID | ID of the ERP entity, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N. |
SQSE_ERP_IDENTIFIER4_ID | ID of the ERP entity, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N. |
SQSE_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQSE_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQSE_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQSE_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SQSE_TOTAL_INMSSQL_SUM | Total amount of time SQL Server was actively executing queries. It is also the sum of the columns. |
SQSE_TOTAL_DURATION_SUM | Total amount of time SQL Server spent executing this statement. |
SQSE_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SQSE_CPU_SUM | Amount of time the process was actively executing a statement. |
SQSE_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. |
SQSE_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQSE_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SQSE_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 COMMIT or ROLLBACK operation. |
SQSE_INTERNAL_WAIT_SUM | Amount of time the process was waiting for an internal resource to be freed. |
SQSE_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SQSE_PARALLEL_EXCHANGE_SUM | Amount of time the thread in a parallel session is waiting for data exchange from another thread. |
SQSE_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SQSE_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SQSE_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SQSE_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SQSE_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SQSE_STAT_OPEN_TRANS_MAX | Number of transaction the process opened. |
SQSE_PARALLEL_DEGREE_MIN | Minimum number of sessions executing this statement in parallel. |
SQSE_PARALLEL_DEGREE_MAX | Maximum number of sessions executing this statement in parallel. |
SQSE_LOCK_ROW_SUM | Amount of time the process was waiting to acquire a lock on a row. |
SQSE_LOCK_KEY_SUM | Amount of time the process was waiting to acquire a lock on an index key or an index key range. |
SQSE_LOCK_PAGE_SUM | Amount of time the process was waiting to acquire a lock on a table or index page. |
SQSE_LOCK_TABLE_SUM | Amount of time the process was waiting to acquire a lock on a table. |
SQSE_COMPILE_LOCK_SUM | Amount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure. |
SQSE_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. |
SQSE_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. |
SQSE_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. |
SQSE_RECIEVED_TIMESTAMP Local date and time the row was loaded into the PMDB.
SQSE_ROWID Unique row number.
SQSE_START_BIT_ID For future use.
SQSE_CLR_WAIT_SUM Groups all the CLR-related waits.
SQSE_INTERNAL_WAIT_SUM Groups all the waits from Internal groups.
SQSE_NET_IO_WAIT_SUM Groups all I/O related wait types.
SQSE_TEMP_DB_WAIT_SUM Groups I/O / Latch on TempDB pages.
SQSE_IDLE_WAIT_SUM This group includes the events indicating that a session is waiting for something other than a user request.
SQSE_INTRNL_BP_WAIT_SUM This state groups the events, which all mean contention on pages in the buffer pool.
SQSE_INTRNL_LATCH_WAIT_SUM This group includes all Latch related wait types.
SQSE_INTRNL_PARALLEL_WAIT_SUM Amount of time the process was waiting for one of its sub-threads to complete its operation.
SQSE_INTRNL_DTC_WAIT_SUM Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQSE_INTRNL_DBMIRROR_WAIT_SUM Aggregates a couple of new waits that occur when DB Mirroring is used.
SQSE_INTRNL_PROFILER_WAIT_SUM Aggregates a number of states associated with the Profiler.
SQSE_INTRNL_MEMORY_WAIT_SUM Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQSE_INTRNL_BACKUP_WAIT_SUM Includes wait types commonly occurring when a session is doing a BACKUP command.
SQSE_INTRNL_OTHER_WAIT_SUM This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
SQSE_NUM_OF_ENDED_SESSIONS_SUM Number of sessions, which ended during the row's timeframe.
SQSE_NUM_OF_SESSIONS_NOT_ENDED Number of sessions, which were still open at the end of the row's timeframe.
SQSE_LOCK_MD_STAT_SUM Aggregates lock waits of the MetaData Statistics type.
SQSE_LOCK_MD_PART_SUM Aggregates lock waits of the MetaData Partition Function type.
SQSE_LOCK_MD_OTHER_SUM Aggregates lock waits of other MetaData types.
SQSE_PC_RECOMPILATIONS_SUM Number of times this plan has been recompiled while it has remained in the cache.
SQSE_PC_CACHE_EVICTIONS_SUM Number of times the plan has been evicted from the cache.
SQSE_PC_EXECUTION_COUNT_SUM Number of times that the plan has been executed.
SQSE_PC_TOTAL_WORKER_TIME_SUM Amount of CPU time that was consumed by executions of this plan.
SQSE_PC_PHYSICAL_READS_SUM Number of physical reads performed by executions of this plan.
SQSE_PC_LOGICAL_READS_SUM Number of logical reads performed by executions of this plan.
SQSE_PC_LOGICAL_WRITES_SUM Number of logical writes performed by executions of this plan.
SQSE_PC_CLR_TIME_SUM Time consumed inside CLR objects by executions of this plan.
SQSE_PC_ELAPSED_TIME_SUM Total elapsed time for completed executions of this plan.