Page History
...
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
SQFA_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQFA_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 SQFA_PWHG_ID should be used. |
SQFA_PWHG_ID | Hour group ID. |
SQFA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQFA_PROGRAM_ID | ID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N. |
SQFA_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQFA_USER_ID | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SQUN_USER_NAMES_N. |
SQFA_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SQFA_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQFA_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQFA_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQFA_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SQFA_PHYSICAL_FILE_ID | ID of the physical file, normalized in table PW_SQFN_FILE_NAMES_N. |
SQFA_LOGICAL_FILE_ID | ID of the logical file, normalized in table PW_SQFN_FILE_NAMES_N. |
SQFA_UNIT_ID | ID of the storage device. |
SQFA_DEVICE_NAME | Name of the storage device. |
SQFA_SFW_DISK_NUMBER | The storage for the Windows disk number as it appears in the Disk Management window in the Computer Management application. |
SQFA_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQFA_FILE_DATABASE_ID | ID of the file database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQFA_FILE_GROUP_ID | Group to which the file belongs. |
SQFA_DEVICE_TYPE | Type of the storage device. |
SQFA_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQFA_ROWID | Unique row number. |
PW_SQDS_DBFILES_STATS_T
Holds statistics on datafiles over time.
| Column Name | Column Description |
|---|---|
SQDS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDS_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 SQDS_PWHG_ID should be used. |
SQDS_PWHG_ID | Hour group ID. |
SQDS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDS_DATABASE_ID | ID of the database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQDS_PHYSICAL_FILE_ID | ID of the physical file, normalized in table PW_SQFN_FILE_NAMES_N. |
SQDS_LOGICAL_FILE_ID | ID of the logical file, normalized in table PW_SQFN_FILE_NAMES_N. |
SQDS_UNIT_ID | ID of the storage device. |
SQDS_DEVICE_NAME | Name of the storage device. |
SQDS_SFW_DISK_NUMBER | The storage for Windows disk number as appears in the Disk Management window in the Computer Management application. |
SQDS_IO_WAIT_SUM | Sum of the I/O wait spent on the device. |
SQDS_FILE_DATABASE_ID | ID of the file database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQDS_FILE_GROUP_ID | Group to which the file belongs. |
SQDS_DEVICE_TYPE | Type of the storage device. |
SQDS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDS_ROWID | Unique row number. |