Page History
...
| Column Name | Column Description |
|---|---|
SQLS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQLS_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 SQLS_PWHG_ID should be used. |
SQLS_PWHG_ID | Hour group ID. |
SQLS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLS_AVG_WAIT_TM_HIT_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_TOTAL_LATCH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLS_ROWID | Unique row number. |
SQLS_AVG_WAIT_TM_HIT_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQPR_PROCESS_T
Holds information on the object Process Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQPR_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPR_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 SQPR_PWHG_ID should be used. |
SQPR_PWHG_ID | Hour group ID. |
SQPR_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPR_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_SQL_SRVR_PAGE_FAULTS_AVG | The overall average rate of faulted pages encountered by the SQL Server process, that are handled by the processor. It is measured in numbers of pages faulted per second. A page fault occurs when a process requires code or data that is not in its working set, i.e. its space in physical memory. This counter includes both hard faults (those that require disk access) and soft faults (where the faulted page is found elsewhere in physical memory). Most processors can handle large numbers of soft faults without consequence. However, hard faults can cause significant delays. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval. |
SQPR_PAGE_FAULTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_WRITES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_AVAILABLE_MB_AVG | The amount of physical memory available to processes running on the computer, in megabytes (Bytes / 1,048,576). It is calculated by summing space on the Zeroed, Free, and Stand by memory lists. Free memory is ready for use; Zeroed memory are pages of memory filled with zeros to prevent later processes from seeing data used by a previous process. Standby memory is memory removed from a process' working set (its physical memory) on route to disk, but is still available to be recalled. This counter displays the last observed value only; it is not an average. |
SQPR_AVAILABLE_MB_MIN | Like the previous counter, but it is the minimum value after doing the summary process. |
SQPR_SERVER_PHYS_MEMORY_MAX | Total physical memory available in the instance machine. |
SQPR_QUEUE_LENGTH_AVG | The number of threads in the processor queue. There is a single queue for processor time, even on computers with multiple processors. Unlike the disk counters, this counter counts ready threads only, not threads that are running. A sustained processor queue of greater than two threads generally indicates processor congestion. This counter displays the last observed value only; it is not an average. |
SQPR_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPR_ROWID | Unique row number. |
PW_SQPO_PROCESSOR_T
Holds information on the object Processor Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQPO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPO_INSTANCE_NAME | Number of the processor. |
SQPO_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 SQPO_PWHG_ID should be used. |
SQPO_PWHG_ID | Hour group ID. |
SQPO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPO_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPO_ROWID | Unique row number. |
PW_SQPD_PHYSICAL_DISK_T
Holds information on the object PhysicalDisk Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQPD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPD_INSTANCE_NAME | Identifier of the disk. |
SQPD_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 SQPD_PWHG_ID should be used. |
SQPD_PWHG_ID | Hour group ID. |
SQPD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPD_AVG_DISK_QUEUE_LENGTH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_READS_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_WRITES_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_WRITES_AVG | The average time in seconds it took to write data to the disk. |
SQPD_DISK_SEC_TRANSFER_AVG | The average time in seconds of the average disk transfer. |
SQPD_DISK_TRANSFER_PER_SEC_AVG | The average number of disk transfers per second. |
SQPD_DISK_SPLIT_IO_PER_SEC_AVG | The average rate that I/Os to the disk were split into multiple I/Os. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented. |
SQPD_PRCT_DISK_READ_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing read requests. |
SQPD_PRCT_DISK_WRITE_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing write requests. |
SQPD_PRCT_IDLE_TIME_AVG | The average percentage of time during the sample interval that the disk was idle. |
SQPD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPD_ROWID | Unique row number. |