Page History
...
| 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. |
PW_SQLS_LOCKS_STATS_T
Holds information on the objects SQL Server: Locks Object and SQL Server: Latch Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| 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_RECIEVED_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.