Page History
...
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_DNCS_COUNTER_STAT_T
This table contains all the performance counters that have been collected and aggregated during the defined interval. It reflects the Perfmon categories and counters, and also contains daily, weekly, and monthly summarization levels.
| Column Name | Column Description |
|---|---|
DNCS_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNCS_TIMESTAMP | The end time of the transaction. |
DNCS_RECEIVED_TIMESTAMP | The received timestamp. |
DNCS_MINUTES_COUNT_SUM | The hours count. |
DNCS_PWHG_ID | The hour group in the PW. |
DNCS_ANONYM_REQ | The number of requests utilizing anonymous authentication. |
DNCS_CACHE_ENTRIES | The number of entries within the cache. |
DNCS_CACHE_HITS | The number of hits from the cache. |
DNCS_CACHE_MISSES | The number of failed cache requests per application. |
DNCS_CACHE_API_ENTRIES | The number of entries in the application cache from external Cache APIs. |
DNCS_CACHE_API_HITS | The number of hits from the cache only through the external Cache APIs. |
DNCS_CACHE_API_TURN_RATE | The number of additions and removals to the API cache per second. |
DNCS_CACHE_API_MISSES | The number of failed requests to the cache through the external Cache APIs. |
DNCS_COMPILATIONS | The number of compilations that have taken place. |
DNCS_DEBUG_REQ | The number of requests while debugging was enabled. |
DNCS_ERR_PREPROCESSING | The number of errors during parsing. |
DNCS_ERR_COMPILATION | The number of errors during dynamic compilation. |
DNCS_ERR_EXECUTION | The number of errors during the execution of an HTTP request. |
DNCS_ERR_DURING_EXEC | The number of unhandled errors during the execution of HTTP requests. |
DNCS_ERR_TOTAL | The number of errors during the execution of HTTP requests. |
DNCS_OUT_CACHE_ENTRIES | The number of entries in the output cache. |
DNCS_OUT_CACHE_HITS | The number of requests serviced from the output cache. |
DNCS_OUT_CACHE_MISSES | The number of failed output cache requests per application. |
DNCS_OUT_TURN_RATE | The number of additions and removals to the output cache per second. |
DNCS_PIPELINE_COUNT | The number of active pipeline instances. |
DNCS_REQ_TOTAL_BYTES | The size (in bytes) of all requests. |
DNCS_REQ_OUT_TOTAL | The total size (in bytes) of responses sent to a client. This does not include standard HTTP response headers. |
DNCS_REQ_EXECUTING | The number of requests currently being executed. |
DNCS_REQ_FAILED | The number of failed requests. |
DNCS_REQ_QUEUE | The number of requests in the application request queue. |
DNCS_REQ_NOT_FOUND | The number of requests that failed because resources were not found. |
DNCS_REQ_NOT_AUTHORIZED | The number of requests that failed due to no authorization (Status code 401). |
DNCS_REQ_SUCCEEDED | The number of requests that executed successfully (Status code 200). |
DNCS_REQ_TIME_OUT | The number of requests that timed out. |
DNCS_REQ_TOTAL | The number of requests since the service was started. |
DNCS_SESSION_SQL_CONN | The number of connections to the SQL Server used by session state. |
DNCS_SESSION_SERVER_CONN | The number of connections to the State Server used by session state. |
DNCS_SESSION_ACTIVE | The number of sessions currently active. |
DNCS_SESSION_ABANDONED | The number of sessions that have been explicitly abandoned. |
DNCS_SESSION_TIMEOUT | The number of sessions timed out. |
DNCS_SESSION_TOTAL | The total number of sessions since the application was started. |
DNCS_TRANS_ABORTED | The number of transactions aborted. |
DNCS_TRANS_COMMITTED | The number of transactions committed. |
DNCS_TRANS_PENDING | The number of transactions in progress. |
DNCS_TRANS_TOTAL | The number of transactions since the service was started. |
DNCS_TRANS_TOTAL_SEC | The number of transactions started per second. |
DNCS_APP_RESTART | The number of times that an application has been restarted. |
DNCS_APP_RUN | The number of applications running on the server computer. |
DNCS_REQUEST_DISCON | The number of requests that were disconnected. |
DNCS_REQUEST_EXEC_TIME | The number of milliseconds that it took to execute the most recent request. |
DNCS_REQUEST_CURRENT | The number of requests, including those that are queued, currently executing, or waiting to be written to the client. |
DNCS_REQUEST_REJECT | The number of requests rejected, because the request queue was full. |
DNCS_REQUEST_QUEUED | The number of requests waiting for service from the queue. |
DNCS_REQ_WAIT | The number of milliseconds that the most recent request waited. |
DNCS_WP_RESTARTS | The number of times a worker process has been restarted. |
DNCS_WP_RUNNING | The number of worker processes running on the server computer. |
DNCS_EXCEPTION_THROWN | The number of exceptions thrown since the application started. |
DNCS_FILTERS_SEC | The number of .NET exception filters executed per second. |
DNCS_FINALLY_SEC | The number of finally blocks executed per second. |
DNCS_CATCH_SEC | The number of stack frames traversed. |
DNCS_CCW | The number of managed objects referenced by unmanaged COM code. |
DNCS_MARSHALING | The number of times object have been marshaled from managed to unmanaged code. |
DNCS_STUBS | The number of stubs created by the common language runtime. |
DNCS_IL_BYTES_JITTED | The number of MSIL bytes compiled by the just-in-time (JIT) compiler. |
DNCS_IL_METHODS_JITTED | The number of methods JIT-compiled. |
DNCS_PERCENT_TIME_IN_JIT | Percentage of elapsed time spent in JIT compilation. |
DNCS_JIT_METHODS_FAILED | The number of methods the JIT compiler has failed to compiled. |
DNCS_BYTES_LOADER | Size of the memory committed by the class loader. |
DNCS_APPDOMAINS_CURRENT | The number of application domains loaded. |
DNCS_ASSEMBLIES_CURRENT | The number of assemblies loaded. |
DNCS_CLASSES_CURRENT | The number of classes loaded in all assemblies. |
DNCS_UNLOAD_APPDOMAINS | The number of application domains unloaded. |
DNCS_LOAD_FAIL_MAX | This counter displays the peak number of classes that have failed to load since the start of the application. |
DNCS_APPDOMAINS_MAX | This counter displays the peak number of AppDomains loaded since the start of this application. |
DNCS_APPDOMAINS_UNLOAD_MAX | This counter displays the total number of AppDomains unloaded since the start of the application. |
DNCS_ASSEMBLIES_MAX | This counter displays the total number of Assemblies loaded since the start of this application. |
DNCS_CLASSES_MAX | This counter displays the cumulative number of classes loaded in all Assemblies since the start of this application. |
DNCS_LOGICAL_THREADS | The number of current managed thread objects in the application. |
DNCS_PHYSICAL_THREADS | The number of native operating system threads created by the CLR. |
DNCS_RECO_THREADS | The number of threads that are currently recognized by the runtime. |
DNCS_TOTAL_RECO_THREADS | This counter displays the total number of threads that have been recognized by the CLR since the start of this application. |
DNCS_QUEUE_LENGTH | The number of threads currently waiting to acquire a managed lock. |
DNCS_QUEUE_LENGTH_MAX | This counter displays the total number of threads that waited to acquire some managed lock since the start of the application. |
DNCS_CONTENTIONS | The number of times that threads in the runtime have attempted to acquire a managed lock unsuccessfully. |
DNCS_BYTES_ALL_HEAPS | Memory allocated in bytes on the garbage collection heaps. |
DNCS_GC_HANDLES | The number of garbage collection handles in use. |
DNCS_COLLECT_GEN0 | The number of times the generation 0 objects are garbage collected. |
DNCS_COLLECT_GEN1 | The number of times the generation 1 objects are garbage collected. |
DNCS_COLLECT_GEN2 | The number of times the generation 2 objects are garbage collected. |
DNCS_INDUCED_GC | This counter displays the peak number of times a garbage collection was performed because of an explicit call to |
DNCS_PINNED_OBJECTS | The number of pinned objects encountered in the last garbage collection. |
DNCS_SYNC_BLOCKS | The number of synchronization blocks in use. |
DNCS_COMMITTED_BYTES | Amount of virtual memory, currently committed by the garbage collector. |
DNCS_RESERVED_BYTES | Amount of virtual memory, currently reserved by the garbage collector. |
DNCS_TIME_IN_GC | Percentage of time that was spent performing a garbage collection. |
DNCS_FINAL_SURVIVE | The number of garbage-collected objects that survive a collection. |
DNCS_GEN0_HEAP_SIZE | The number of bytes in generation 0. |
DNCS_GEN1_HEAP_SIZE | The number of bytes in generation 1. |
DNCS_GEN2_HEAP_SIZE | The number of bytes in generation 2. |
DNCS_LARG_HEAP_SIZE | Size of the Large Object Heap. |
DNCS_GEN0_PROMOTE | Bytes of memory that are promoted from generation 0 to generation 1. |
DNCS_GEN1_PROMOTE | Bytes of memory that are promoted from generation 1 to generation 2. |
DNCS_PROMOTE_FROM_GEN0 | This counter displays the bytes of memory that survive garbage collection (GC) and are promoted from generation 0 to generation 1. |
DNCS_PROMOTE_FROM_GEN1 | This counter displays the bytes of memory that survive garbage collection (GC) and are promoted from generation 1 to generation 2. |
DNCS_BYTES_RECEIVED | The number of bytes received over all open socket connections. |
DNCS_BYTES_SENT | The number of bytes sent over all open socket connections. |
DNCS_CONN_ESTABLISHED | The number of socket connections established. |
DNCS_DATAGRAMS_RECEIVED | The number of datagram packets received. |
DNCS_DATAGRAMS_SENT | The number of datagram packets sent. |
DNCS_CHANNELS | The number of remoting channels registered. |
DNCS_CONT_PROXIES | The number of remoting proxy objects. |
DNCS_CONT_BOUND_CLASSES | The number of context-bound classes that are loaded. |
DNCS_CONT | The number of remoting contexts in the application. |
DNCS_REMOTE_CALLS | The number of remote procedure calls invoked. |
DNCS_TIME_CHECK | The number of link-time code access security checks. |
DNCS_PERCENT_RT_CHECK | Percentage of elapsed time spent performing runtime code access security checks. |
DNCS_STACK_DEPTH | Depth of the stack during that last runtime code access security check. |
DNCS_RT_CHECK | The number of runtime code access security checks performed. |
DNCS_CONN_POOLS | Current number of pools associated with the process. |
DNCS_CONNECTIONS | Current number of connections, pooled or not. |
DNCS_POOLED_CONN | Current number of connections in all pools associated with the process. |
DNCS_POOLED_CONN_MAX | The highest number of connections in all pools since the process started. |
DNCS_FAILED_COMMAND | The total number of command executes that have failed for any reason. |
DNCS_FAILED_CONN | The total number of connection open attempts that have failed for any reason. |
DNCS_CPU | CPU consumption. |
DNCS_MEMORY | Memory Usage. |
PW_DNCD_COUNTER_DYNAMIC_STAT_T
This table contains all the dynamic 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 |
|---|---|
DNCD_PWII_INSTANCE_ID | The unique identifier of the instance. |
DNCD_TIMESTAMP | The end time of the transaction. |
DNCD_RECEIVED_TIMESTAMP | The received timestamp. |
DNCD_MINUTES_COUNT_SUM | The hours count. |
DNCD_PWHG_ID | The hour group in the PW. |
DNCD_DNCC_CATEGORY CODE | The counter category. |
DNCD_COUNTER_NAME | The counter name. |
DNCD_COUNTER_DESC | The counter full name (logical key). |
DNCD_COUNTER_TYPE | SUM/MIN/MAX/AVG. |
DNCD_VALUE_SUM | Counter value when type is SUM. |
DNCD_VALUE_AVG | Counter value when type is AVG. |
DNCD_VALUE_MAX | Counter value when type is MAX. |
DNCD_VALUE_MIN | Counter value when type is MIN. |
PW_DNSS_SERVER_STAT_T
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 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. |