Page History
...
| 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_ |
...
RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQNS_ROWID | Unique row number. |
SQNS_INTRNL_ |
...
BO_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. |