Page History
...
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. |
PW_SQXM_XP_MAPPING
Holds mapping disks of HP or HDS systems.
| Column Name | Column Description |
|---|---|
SQXM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQXM_PHYSICAL_DISK | Physical disk number. |
SQXM_DEVICE_NAME | Name of the device. |
SQXM_ARRAY_ID | ID of the array. |
SQXM_CONTROL_UNIT | Control unit identifier. |
SQXM_LDEV_ID | ID of the logical device. |
SQXM_RAID_GROUP | Name of the raid group. |
SQXM_CHP_ID | Identification number of the Client Host Interface Processor Port of the logical device. |
SQXM_ACP_PAIR_ID | Identification number of the Array Control Processor Pair of the logical device. |
SQXM_URL | Vendor-specific performance URL. |
PW_SQOU_OBJECTS_SPACE_USAGE_D
Holds statistics on objects space. By default, this process runs every 24 hours.
| Column Name | Column Description |
|---|---|
SQOU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQOU_DATABASE_ID | Name of the database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQOU_OBJECT_ID | ID of the table. |
SQOU_FULL_OBJECT_ID | The full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
SQOU_INDEX_ID | ID of the index. |
SQOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQOU_PWHG_ID | Hour group ID. |
SQOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQOU_O_ALL_ALLOC_MAX | Number of pages allocated to the object. |
SQOU_O_ALL_USED_MAX | Number of pages used by the object. |
SQOU_O_TEXT_ALLOC_MAX | Number of text pages allocated to the object. |
SQOU_O_TEXT_USED_MAX | Number of text pages used by the object. |
SQOU_O_DATA_USED_MAX | Number of data pages used by the objects. |
SQOU_O_INDEX_ALLOC_MAX | Number of pages allocated to the indexes of the object. |
SQOU_O_INDEX_USED_MAX | Number of pages used by the indexes of the object. |
SQOU_ROW_COUNT_MAX | Number of rows the object has. |
SQOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQOU_ROWID | Unique row number. |
SQOU_SYSTEM_SEEKS_SUM | Number of system seeks per one object. |
SQOU_SYSTEM_SCANS_SUM | Number of system scans per one object. |
SQOU_SYSTEM_LOOKUPS_SUM | Number of system lookups per one object. |
SQOU_SYSTEM_UPDATES_SUM | Number of system updates per one object. |
SQOU_USER_SEEKS_SUM | Number of user seeks per one object. |
SQOU_USER_SCANS_SUM | Number of user scans per one object. |
SQOU_USER_LOOKUPS_SUM | Number of user lookups per one object. |
SQOU_USER_UPDATES_SUM | Number of user updates per one object. |