Page History
...
Holds information on the object SQL Server: SQL Statistics Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQPS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPS_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 SQPS_PWHG_ID should be used. |
SQPS_PWHG_ID | Hour group ID. |
SQPS_MINUTES_COUNT_SUM | The timeframe needed to calculate the row, in minutes. |
SQPS_AUTO_PARAM_ATTEMPTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH-REQUESTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH_REQUESTS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_ |
...
FAILED_AUTO_PARAMS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_ |
...
AUTOPARAMS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_SQL_COMPILE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_SQL_RE_COMPILE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_UNSAFE_AUTO_ |
...
PARAM_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GENERAL_STAT_LOGINS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GENERAL_STAT_LOGINS_MAX | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GENERAL_STAT_LOGOUTS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GENERAL_STAT_USR_CONN_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GENERAL_STAT_USR_CONN_MAX | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT1_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT2_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT3_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT4_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT5_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT6_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT7_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT8_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT9_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_USER_SETTABLE_CNT10_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_ |
...
RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPS_ROWID | Unique row number. |
SQPS_GNRL_ACTIVE_TEMP_TAB_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_LOGICAL_CON_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_MARS_DEADLOCKS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_NATOM_YIELD_RATE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_PROC_BLOCK_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_TMP_TAB_CRT_RATE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TMP_ |
...
DSTRUCT_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_GNRL_TRANSACTIONS_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_ETIME_DSTR_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_ETIME_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_EXT_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_ |
...
OLE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_ |
...
INPROG_ |
...
DSTR_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |
SQPS |
...
_STAT_E_INPROG_DSTR_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_INPROG_DTC_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_INPROG_EXT_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_INPROG_OLE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_PERSEC_DSTR_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_PERSEC_DTC_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_PERSEC_EXT_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_EX_STAT_E_PERSEC_OLE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_FORCED_PARM_SEC_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_TRANS_VER_CLNUP_RATE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_TRANS_VER_GNRT_RATE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. | |
SQPS_TRANS_VER_STORE_SIZE_AVG | For more information, search for |
...
| "performance counters" on http://msdn.microsoft.com. |