Page History
...
Holds information on the object SQL Server: Databases Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQDD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDD_INSTANCE_NAME | Name of the database. |
SQDD_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 SQDD_PWHG_ID should be used. |
SQDD_PWHG_ID | Hour group ID. |
SQDD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDD_ACTIVE_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BACKUP_RES_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_ROWS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DATA_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DBCC_LOGICAL_SCAN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_BYTES_FLUSHED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAITS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_GROWTHS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_SHRINKS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_TRUNCATIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_PERCENT_LOG_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_PENDING_XACTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_TRANS_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_SHRINK_DATA_MOVEMENT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDD_ROWID | Unique row number. |
PW_SQPS_SQL_STATISTIC_STATS_T
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_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 calculated 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_AUTO_PARAMS_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_PARM_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_RECIEVED_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_TAB_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_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.