Page History
...
| 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_RECEIVED_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. |
PW_SQNS_INSTANCE_STATS_T
Stores application performance statistics per timeslice for every combination of instance and database.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
SQNS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQNS_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 SQNS_PWHG_ID should be used. |
SQNS_PWHG_ID | Hour group ID. |
SQNS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQNS_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQNS_TOTAL_INMSSQL_SUM | Total amount of time SQL Server was actively executing queries. It is also the sum of the columns. |
SQNS_TOTAL_DURATION_SUM | Total amount of time SQL Server spent executing this statement. |
SQNS_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SQNS_CPU_SUM | Amount of time the process was actively executing a statement. |
SQNS_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. |
SQNS_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQNS_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SQNS_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. |
SQNS_INTERNAL_WAIT_SUM | Amount of time the process was waiting for an internal resource to be freed. |
SQNS_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SQNS_PARALLEL_EXCHANGE_SUM | Amount of time the thread in a parallel session is waiting for data exchange from another thread. |
SQNS_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SQNS_NUM_OF_SESSIONS_NOT_ENDED | Number of sessions, which were still open at the end of the row's timeframe. |
SQNS_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SQNS_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SQNS_STAT_CPU_SUM | Statistics summing the amount of the process's read memory usage. |
SQNS_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SQNS_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SQNS_STAT_OPEN_TRANS_MAX | Number of transaction the process opened. |
SQNS_LOCK_ROW_SUM | Amount of time the process was waiting to acquire a lock on a row. |
SQNS_LOCK_KEY_SUM | Amount of time the process was waiting to acquire a lock on an index key or an index key range. |
SQNS_LOCK_PAGE_SUM | Amount of time the process was waiting to acquire a lock on a table or index page. |
SQNS_LOCK_TABLE_SUM | Amount of time the process was waiting to acquire a lock on a table. |
SQNS_OTHER_LOCK_SUM | Amount of time the process was waiting to acquire a lock that is unrecognized by Precise for SQL Server. |
SQNS_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.
SQNS_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.
SQNS_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.
SQNS_RECIEVED_TIMESTAMP Local date and time the row was loaded into the PMDB.
SQNS_ROWID Unique row number.
SQNS_INTRNL_BP_WAIT_SUM This state groups the events, which all mean contention on pages in the buffer pool.
SQNS_INTRNL_LATCH_WAIT_SUM This group includes all Latch related wait types.
SQNS_INTRNL_PARALLEL_WAIT_SUM Aggregates the waits that indicates that session is waiting for one of its sub-threads to complete its operation.
SQNS_INTRNL_DTC_WAIT_SUM Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQNS_INTRNL_DBMIRROR_WAIT_SUM Aggregates a couple of new waits that occur when DB Mirroring is used.
SQNS_INTRNL_PROFILER_WAIT_SUM Aggregates a number of states associated with the Profiler.
SQNS_INTRNL_MEMORY_WAIT_SUM Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQNS_INTRNL_BACKUP_WAIT_SUM Includes wait type commonly occurring when a session is doing a BACKUP command.
SQNS_INTRNL_OTHER_WAIT_SUM This aggregates all the waits that do not match any of the Precise for MS-SQL Server states.
SQNS_PC_RECOMPILATIONS_SUM Number of times this plan has been recompiled while it has remained in the cache.
SQNS_PC_CACHE_EVICTIONS_SUM Number of times the plan has been evicted from the cache.
SQNS_PC_EXECUTION_COUNT_SUM Number of times that the plan has been executed
SQNS_PC_TOTAL_WORKER_TIME_SUM Amount of CPU time that was consumed by executions of this plan.
SQNS_PC_PHYSICAL_READS_SUM Number of physical reads performed by executions of this plan.
SQNS_PC_LOGICAL_READS_SUM Number of logical reads performed by executions of this plan.
SQNS_PC_LOGICAL_WRITES_SUM Number of logical writes performed by executions of this plan.
SQNS_PC_CLR_TIME_SUM Time consumed inside CLR objects by executions of this plan.
SQNS_PC_ELAPSED_TIME_SUM Total elapsed time for completed executions of this plan.
SQNS_LOCK_MD_STAT_SUM Aggregates lock waits of MetaData Statistics type.
SQNS_LOCK_MD_PART_SUM Aggregates lock waits of MetaData Partition Function type.
SQNS_LOCK_MD_OTHER_SUM Aggregates lock waits of other MetaData types.
SQNS_CLR_WAIT_SUM Groups all the CLR-related waits.
SQNS_INTERNAL_WAIT_SUM Groups all the waits from Internal groups.
SQNS_NET_IO_WAIT_SUM Groups all I/O related wait types.
SQNS_TEMP_DB_WAIT_SUM Groups I/O / Latch on TempDB pages.
SQNS_IDLE_WAIT_SUM This group will include the events indicating that a session is waiting for something other than a user request.
SQNS_INTRNL_BP_WAIT_SUM This state groups the events, which all mean contention on pages in the buffer pool.
SQNS_INTRNL_LATCH_WAIT_SUM This group includes all Latch related wait types.
SQNS_INTRNL_PARALLEL_WAIT_SUM Aggregates the waits that indicate that a session is waiting for one of its sub-threads to complete its operation.
SQNS_INTRNL_DTC_WAIT_SUM Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQNS_INTRNL_DBMIRROR_WAIT_SUM Aggregates a couple of new waits that occur when DB Mirroring is used.
SQNS_INTRNL_PROFILER_WAIT_SUM Aggregates a number of states associated with the Profiler.
SQNS_INTRNL_MEMORY_WAIT_SUM Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQNS_INTRNL_BACKUP_WAIT_SUM Includes wait types commonly occurring when a session is doing a BACKUP command.
SQNS_INTRNL_OTHER_WAIT_SUM This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.