Application Insights detail graphs and metrics

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Application Insights Detail Graphs and Metrics

    The Application Insights detail graphs offer insights into various metrics at the node level, which are crucial for monitoring the performance and health of your ServiceNow instance. These metrics help you track the efficiency of event processing, ECC queue statistics, session information, and database performance.

    Show full answer Show less

    Key Features

    • Events Metrics:
      • Processed: Reflects the number of events processed.
      • Logged: Indicates the number of events logged.
    • ECC Queue Metrics:
      • Ready on Output: Average entries in the Ready state for the ECC output queue.
      • Ready on Input: Average entries in the Ready state for the ECC input queue.
      • Processing on Output: Average entries in the Processing state for the ECC output queue.
      • Processing on Input: Average entries in the Processing state for the ECC input queue.
      • Processed on Output: Average entries in the Processed state for the ECC output queue.
      • Processed on Input: Average entries in the Processed state for the ECC input queue.
    • Session Information Metrics:
      • Average Transaction Response Time: Average processing time for transactions.
      • Transaction Count: Load of transactions on the instance.
      • Logged in Users: Number of users logged into the instance over time.
      • Semaphore Metrics: Various metrics related to queue depths and rejections for API integrations and AMB queues.
      • Average Database Response Time: Average response time for database operations.
      • Database Throughput: Transactions processed per second.

    Key Outcomes

    By utilizing these detail graphs and metrics, ServiceNow customers can effectively monitor their instance's performance, identify bottlenecks, and make informed decisions to optimize transaction processing and overall system health. Understanding these metrics allows for proactive management and enhanced service delivery.

    The Application Insights detail graphs provide views of individual metrics at the node level.

    Table 1. Events detail graphs
    Metric Source Description
    Events Processed events_processed key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of events processed
    Events Logged event_logs key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of events logged
    Table 2. ECC Queue detail graphs
    Metric Source Description
    Ready on Output ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Ready state in the ECC output queue
    Ready on Input ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Ready state in the ECC input queue
    Processing on Output ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Processing state in the ECC output queue
    Processing on Input ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Processing state in the ECC input queue
    Processed on Output ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Processed state in the ECC output queue
    Processed on Input ECC Queue Statistics [ecc_queue_stats_by_ecc_agent] table Average number of entries in the Processed state in the ECC input queue
    Table 3. Session information detail graphs
    Metric Source Description
    Average Transaction Response Time transactions key in the Stats column in the Node stats [sys_cluster_node_stats] table Average transaction processing time in seconds
    Transaction Count transactions key in the Stats column in the Node stats [sys_cluster_node_stats] table Load of transactions on the instance
    Logged in Users sessionsummary key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of users logged in to the instance over time
    Semaphore API_INT Queue Depth semaphores key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions in the API Integrations semaphore queue
    Semaphore Default Queue Depth semaphores key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions in the Default semaphore queue
    Semaphore AMB Send Queue Depth semaphores key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of messages in the AMB Send queue being sent to the client
    Semaphore AMB Receive Queue Depth semaphores key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of messages in the AMB Send queue being received from the client
    Semaphore API_INT Rejections semaphore_api_int_rejection key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions rejected by the API Integrations semaphore queue
    Semaphore Default Rejections semaphore_default_rejected key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions rejected by the Default semaphore queue
    Semaphore AMB Send Rejections semaphore_amb_send_rejected key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions rejected by the AMB Send queue
    Semaphore AMB Receive Rejections semaphore_amb_receive_rejected key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions rejected by the AMB Receive queue
    Average Database Response Time sql_response key in the Stats column in the Node stats [sys_cluster_node_stats] table Average response time (in milliseconds) for database operations
    Database Throughput database_throughput key in the Stats column in the Node stats [sys_cluster_node_stats] table Number of transactions processed per second.