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_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.
...