Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Old Version 3

changes.mady.by.user Nadja Pollard

Saved on Mar 11, 2021

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on Mar 11, 2021

Key

This line was added.
This line was removed.
Formatting was changed.

...

This table contains all the server performance counters that have been collected and aggregated during the defined interval. It also contains daily, weekly, and monthly summarization levels.

Column Name	Column Description
`DNSS_PWII_INSTANCE_ID`	The unique identifier of the instance.
`DNSS_TIMESTAMP`	The end time of the transaction.
`DNSS_RECEIVED_TIMESTAMP`	The received timestamp.
`DNSS_MINUTES_COUNT_SUM`	The hours count.
`DNSS_PWHG_ID`	The hour group in the PW.
`DNSS_DNCC_CATEGORY CODE`	The counter category.
`DNSS_COUNTER_NAME`	The counter name.
`DNSS_COUNTER_DESC`	The counter full name (logical key).
`DNSS_COUNTER_TYPE`	SUM/MIN/MAX/AVG.
`DNSS_VALUE_SUM`	Counter value when type is SUM.
`DNSS_VALUE_AVG`	Counter value when type is AVG.
`DNSS_VALUE_MAX`	Counter value when type is MAX.
`DNSS_VALUE_MIN`	Counter value when type is MIN.

PW_DNMC_METHOD_CONTEXT

This table contains the method context (Method/Caller).

Column Name	Column Description
`DNMC_METHOD_NAME`	The name of the method.
`DNMC_METHOD_SHORT_NAME`	The short name of the method.
`DNMC_METHOD_CONTEXT`	The method context.
`DNMC_CALLER_CONTEXT`	The caller context.
`DNMC_ROOT_CONTEXT`	The root context.
`DNMC_CHANGED_DT`	The last changed date.
`DNMC_IS_DELETED`	The deleted Ind.

PW_DNIS_INVOCATIONS_STAT_T

This table contains the invocation information with specific context. It also contains daily, weekly, and monthly summarization levels.

Column Name	Column Description
`DNIS_PWII_INSTANCE_ID`	The unique identifier of the instance.
`DNIS_TIMESTAMP`	The end time of the transaction.
`DNIS_RECEIVED_TIMESTAMP`	The received timestamp.
`DNIS_MINUTES_COUNT_SUM`	The hours count.
`DNIS_PWHG_ID`	The hour group in the PW.
`DNIS_INVOCATION_CONTEXT`	The context.
`DNIS_URI_TYPE_CODE`	The URI type.
`DNIS_INVOCATION_TYPE_CODE`	The invocation type.
`DNIS_INVOCATIONS_COUNT_SUM`	The invocation count.
`DNIS_RESPONSE_TIME_SUM`	The summarized response time.
`DNIS_RESPONSE_TIME_MAX`	The maximum response time.
`DNIS_RESPONSE_TIME_MIN`	The minimum response time.
`DNIS_INVOCATIONS_TIME_SUM`	The summarized invocation time.
`DNIS_CPU_TIME_SUM`	The summarized CPU time.
`DNIS_DB_TIME_SUM`	The summarized DB time.
`DNIS_WS_TIME_SUM`	The summarized WS time.
`DNIS_GREEN_SUM`	Sum green.
`DNIS_YELLOW_SUM`	Sum yellow.
`DNIS_RED_SUM`	Sum red.
`DNIS_HAS_CHILD`	The has child indicator.
`DNIS_DEPTH`	The depth.

PW_DNSI_SQL_INVOC_STAT_T

This table contains the SQL invocation information in context. It also contains daily, weekly, and monthly summarization levels.

Column Name	Column Description
`DNSI_PWII_INSTANCE_ID`	The unique identifier of the instance.
`DNSI_TIMESTAMP`	The end time of the transaction.
`DNSI_RECEIVED_TIMESTAMP`	The received timestamp.
`DNSI_MINUTES_COUNT_SUM`	The hours count.
`DNSI_PWHG_ID`	The hour group in the PW.
`DNSI_DNMI_METHOD_CONTEXT`	The context.
`DNSI_DNSQ_SQL_ID`	The ID of the SQL process.
`DNSI_DNSQ_RESPONSE_TIME_SUM`	The summarized response time.
`DNSI_DNSQ_RESPONSE_TIME_MAX`	The maximum response time.
`DNSI_INVOCATIONS_COUNT_SUM`	The invocation count.
`DNSI_CONN_STRING`	The connection string.
`DNSI_DB_ID`	The ID of the database.
`DNSI_SERVER_ID`	The server name.
`DNSI_DEPTH`	The depth.

PW_DNAV_AVAIL_STAT_T

This table contains the availability information. It also contains daily, weekly, and monthly summarization levels.

Column Name	Column Description
`DNAV_PWII_INSTANCE_ID`	The unique identifier of the instance.
`DNAV_TIMESTAMP`	The end time of the transaction.
`DNAV_RECEIVED_TIMESTAMP`	The received timestamp.
`DNAV_MINUTES_COUNT_SUM`	The minutes count in the PW.
`DNAV_PWHG_ID`	The hour group in the PW.
`DNAV_PARALLEL_EXEC_AVG`	The average number of parallel processes.
`DNAV_REAL_AVAILABILITY_AVG`	The normalized availability.
`DNAV_AVAIL_WITH_DOWNTIME_AVG`	The availability for normalized downtime.

PW_DNCA_CURR_AVAIL

This table contains the current availability information.

Column Name	Column Description
`DNCA_PWII_INSTANCE_ID`	The unique identifier of the instance.
`DNCA_TIMESTAMP`	The end time of the transaction.
`DNCA_IS_AVAIL`	Is available.

PW_DNCC_COUNTER_CATEGORY_N

This table contains the normalized counter categories (ASP.NET general, ASP.NET specific, CLR memory, CLR JIT, and so on).

Column Name	Column Description
`DNCC_ID`	The unique identifier of the instance.
`DNCC_HASH_VALUE`	The hash value of the instance.
`DNCC_STRING_VALUE`	The category name of the instance.
`DNCC_TIMESTAMP`	The timestamp of the transaction.

PW_DNSD_SQL_DB_N

This table contains the normalized database name from the connection string.

Column Name	Column Description
`DNSD_ID`	The unique identifier of the instance.
`DNSD_HASH_VALUE`	The hash value of the instance.
`DNSD_STRING_VALUE`	The database name of the instance.
`DNSD_TIMESTAMP`	The timestamp of the transaction.

PW_DNSS_SQL_SERVER_N

This table contains the normalized server name form from the SQL connection string.

Column Name	Column Description
`DNSS_ID`	The unique identifier of the instance.
`DNSS_HASH_VALUE`	The hash value of the instance.
`DNSS_STRING_VALUE`	The server name of the instance.
`DNSS_TIMESTAMP`	The timestamp of the transaction.

PW_DNSQ_SQL_N

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`	0 = Web 1 = Non-Web (no need to use DIM table)

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: `PS_INCE_INSTANCE`.
`DNIV_NAME`	The name of the instance. Base table: `PS_INCE_INSTANCE`.
`DNIV_INTE_CODE`	The technology code (DN) of the instance. Base table: `PS_INCE_INSTANCE`.
`DNIV_INSM_ID`	The unique identifier of the server. Base table: `PS_INSM_SERVER_MACHINE`.
`DNIV_INSM_NAME`	The name of the server. Base table: `PS_INCE_INSTANCE`.
`DNIV_CREATE_TIME`	The time the instance was created. Base table: `PS_INCE_INSTANCE`.
`DNIV_UPDATE_TIME`	The time the instance was updated. Base table: `PS_INCE_INSTANCE`.
`DNIV_DELETED`	Is deleted. Base table: `PS_INCE_INSTANCE`.
`DNIV_INSTANCE_TYPE`	0 = Web 1 = Non-Web (no need to use the DIM table) Base table: `PS_DNIN_INSTANCES`.
`DNIV_INAP_ID`	The unique identifier of the environment. Base table: `PS_INCE_INSTANCE`.

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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools