Page History
...
| 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_ |
...
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. |