Page History
...
This table contains the normalized SQL names.
Column Name | Column Description |
---|---|
DNSQ_SQL_ID | The unique identifier of the instance. |
DNSQ_SQL_HASH_VALUE | The SQL hash value of the SQL statement. |
DNSQ_SQL_STRING | The SQL string of the instance. |
DNSQ_CHANGED_DT | The last change date. |
DNSQ_IS_DELETED | The deleted Ind. |
DNSQ_LAUNCH_HASH_CODE | The launch SQL hash value of the SQL statement. |
PW_DNST_STATEMENTS_N
This table contains the SQL statements.
Column Name | Column Description |
---|---|
DNST_SQL_ID | The unique identifier of the instance. |
DNST_TEXT | The text of the instance. |
DNST_HASH_CODE | The hash value of the instance. |
DNST_CHANGED_DT | The last change date. |
DNST_IS_DELETED | The deleted Ind. |
PW_DNCS_CONNECTION_STRING_N
The table contains the connection strings.
Column Name | Column Description |
---|---|
DNCS_CONNECTION_STRING_ID | The unique identifier of the connection string. |
DNCS_CONNECTION_STRING | The connection string text. |
PW_DNSQ_SEQ
This table contains the sequences.
Column Name | Column Description |
---|---|
DNSQ_TABLE_COLUMN | The column. |
DNSQ_NEXT_FREE_SEQ | The next free sequence. |
PW_DNIN_INSTANCES
This table contains the .NET instance types.
Column Name | Column Description |
---|---|
DNIN_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNIN_INSTANCE_TYPE |
|
PW_DNCE_COUNTER_EXPLAIN
This table contains the explanation of the counters from Perfmon.
Column Name | Column Description |
---|---|
DNCE_COUNTER_NAME | The name of the counter. |
DNCE_COUNTER_CATEGORY | The category of the counter. |
DNCE_COUNTER_EXPLAIN | The counter explanation. |
PW_DNWS_WEB_SERVICES
This table contains the Web services information.
Column Name | Column Description |
---|---|
DNWS_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNWS_DNMI_METHOD_CONTEXT | The method context foreign key. |
DNWS_URL_STRING | The Web service URL. |
PS_DNIV_INSTANCE_VIEW
This table contains the instances view.
Column Name | Column Description |
---|---|
DNIV_ID | The unique identifier of the instance. Base table: |
DNIV_NAME | The name of the instance. Base table: |
DNIV_INTE_CODE | The technology code (DN) of the instance. Base table: |
DNIV_INSM_ID | The unique identifier of the server. Base table: |
DNIV_INSM_NAME | The name of the server. Base table: |
DNIV_CREATE_TIME | The time the instance was created. Base table: |
DNIV_UPDATE_TIME | The time the instance was updated. Base table: |
DNIV_DELETED | Is deleted. Base table: |
DNIV_INSTANCE_TYPE |
|
DNIV_INAP_ID | The unique identifier of the environment. Base table: |
PW_DNAM_ANCESTOR_METHODS
This table contains the hierarchy of the methods.
Column Name | Column Description |
---|---|
DNAM_METHOD_CONTEXT | The method context. |
DNAM_ANCESTOR_CONTEXT | The ancestor method context. |
DNAM_ANCESTOR_DEPTH | The ancestor depth. |
DNAM_CHANGED_DT | The last change date. |
DNAM_IS_DELETED | The deleted Ind. |
PW_DNBN_INVOCATION_BITS_N
Normalization table for the correlated methods in SmartLink.
Column Name | Column Description |
---|---|
DNBN_ID | The unique identifier of the instance. |
DNBN_HASH_VALUE | The hash value of the instance. |
DNBN_STRING_VALUE | The method name of the instance. |
DNBN_TIMESTAMP | The end time of the transaction. |
PW_DNIB_INVOCATION_BITS_T
This table contains the bit vector of the methods.
Column Name | Column Description |
---|---|
DNIB_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNIB_TIMESTAMP | The end time of the transmission. |
DNIB_RECEIVED_TIMESTAMP | The received timestamp. |
DNIB_MINUTES_COUNT_SUM | The minutes count in the PMDB database. |
DNIB_PWHG_ID | The hour group in the PMDB database. |
DNIB_METHOD_ID | The method ID. |
DNIB_METHOD_TYPE_CODE | The method type code. |
DNIB_SERVICE_TIME_SUM | The summarized service time. |
DNIB_INVOCATIONS_SUM | The invocations summary. |
DNIB_BIT_VECTOR | The bit vector. |
DNIB_RED_SUM | Sum red. |
DNIB_YELLOW_SUM | Sum yellow. |
DNIB_GREEN_SUM | Sum green. |
DNIB_IDENTIFIER_1 | Identifier 1. |
DNIB_IDENTIFIER_2 | Identifier 2. |
DNIB_IDENTIFIER_3 | Identifier 3. |
DNIB_IDENTIFIER_4 | Identifier 4. |
PW_DNSR_SMARTUNE_RESULTS_T
This table contains the SmarTune results.
Column Name | Column Description |
---|---|
DNSR_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNSR_TIMESTAMP | The end time of the transmission. |
DNSR_RECEIVED_TIMESTAMP | The received timestamp. |
DNSR_MINUTES_COUNT_SUM | The minutes count in the PMDB database. |
DNSR_PWHG_ID | The hour group in the PMDB database. |
DNSR_PROBLEM_ID | The problem ID. |
DNSR_RANK_MAX | The problem rank. |
DNSR_FINDINGS_COUNT_SUM | The number of findings. |
DNSR_METHOD_CONTEXT | The method context. |
DNSR_IDENTIFIER1 | Identifier 1. |
DNSR_IDENTIFIER2 | Identifier 2. |
DNSR_IDENTIFIER3 | Identifier 3. |
DNSR_IDENTIFIER4 | Identifier 4. |
DNSR_IDENTIFIER5 | Identifier 5. |
DNSR_PARAMETER1_MAX | Counter value when type is MAX. |
DNSR_PARAMETER2_MAX | Counter value when type is MAX. |
DNSR_PARAMETER3_MAX | Counter value when type is MAX. |
DNSR_PARAMETER4_MAX | Counter value when type is MAX. |
DNSR_PARAMETER5_MAX | Counter value when type is MAX. |
DNSR_PARAMETER6_MIN | Counter value when type is MIN. |
DNSR_PARAMETER7_MIN | Counter value when type is MIN. |
DNSR_PARAMETER8_MIN | Counter value when type is MIN. |
DNSR_PARAMETER9_MIN | Counter value when type is MIN. |
DNSR_PARAMETER10_MIN | Counter value when type is MIN. |
DNSR_PARAMETER11_SUM | Counter value when type is SUM. |
DNSR_PARAMETER12_SUM | Counter value when type is SUM. |
DNSR_PARAMETER13_SUM | Counter value when type is SUM. |
DNSR_PARAMETER14_SUM | Counter value when type is SUM. |
DNSR_PARAMETER15_SUM | Counter value when type is SUM. |
DNSR_THRESHOLD1 | The problem threshold. |
DNSR_THRESHOLD2 | The problem threshold. |
DNSR_THRESHOLD3 | The problem threshold. |
DNSR_THRESHOLD4 | The problem threshold. |
DNSR_THRESHOLD5 | The problem threshold. |
PW_DNSP_SMARTUNE_PROBLEM
This table contains the SmarTune problems.
Column Name | Column Description |
---|---|
DNSP_PROBLEM_ID | The problem ID. |
DNSP_PROBLEM_NAME | The problem name. |
DNSP_IS_DISPLAYED | The display indicator. |