Precise Application Performance Platform 10.3.x

Page History

Versions Compared

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)

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