Page History
...
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
SQLA_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQLA_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 SQLA_PWHG_ID should be used. |
SQLA_PWHG_ID | Hour group ID. |
SQLA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLA_PROGRAM_ID | ID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N. |
SQLA_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQLA_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. |
SQLA_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQLA_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQLA_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQLA_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SQLA_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SQLA_LOCKED_OBJECT_TYPE | Type of object being locked (such as table and file). |
SQLA_LOCKED_OBJECT_ID | The ID of the locked object, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
| These three columns combine together the locked object's identifier in SQL Server. For example: a locked index is represented by:
|
SQLA_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLA_ROWID | Unique row number. |
SQLA_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
PW_SQLO_LOCK_OBJECT_STATS_T
Stores application lock statistics per timeslice for every combination of Instance, database and locked objects.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
SQLO_PWII_INSTANCE | ID of the SQL Server instance. |
SQLO_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 SQLO_PWHG_ID should be used. |
SQLO_PWHG_ID | Hour group ID. |
SQLO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLO_DATABASE_ID | ID of the database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQLO_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SQLO_LOCKED_OBJECT_TYPE | Type of object being locked, such as table and file. |
SQLO_LOCKED_OBJECT_ID | The ID of the locked object, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
| These three columns combine together the locked object's identifier in SQL Server. For example: a locked index is represented by:
|
SQLO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLO_ROWID | Unique row number. |