Application Insights detail graphs and metrics

  • Release version: Yokohama
  • Updated January 30, 2025
  • 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

    Application Insights detail graphs in ServiceNow Yokohama release provide granular views of key performance metrics at the node level. These metrics help you monitor and analyze system events, ECC queue statuses, session information, semaphore queues, and database performance. Understanding these metrics enables better operational oversight and troubleshooting for your instance.

    Show full answer Show less

    Key Metrics and Their Sources

    • Events Metrics:
      • Events Processed: Number of events processed, sourced from the eventsprocessed key in the sysclusternodestats table.
      • Events Logged: Number of events logged, from the eventlogs key in the same table.
    • ECC Queue Metrics: Provided by the eccqueuestatsbyeccagent table, these show average counts of entries in various ECC queue states, including Ready, Processing, and Processed for both input and output queues.
    • Session Information Metrics: Key session and transaction metrics from the sysclusternodestats table, such as:
      • Average Transaction Response Time (seconds)
      • Transaction Count (load on the instance)
      • Logged-in Users over time
    • Semaphore Queue Metrics: Metrics showing queue depths and rejection counts for various semaphore queues (APIINT, Default, AMB Send, AMB Receive), all sourced from semaphore-related keys in sysclusternodestats.
    • Database Performance Metrics:
      • Average Database Response Time (in milliseconds)
      • Database Throughput (transactions processed per second)

    Practical Benefits for ServiceNow Customers

    By leveraging these detailed graphs and metrics, you can:

    • Monitor real-time processing of events and ECC queue health to ensure smooth integration and communication between nodes.
    • Track user sessions and transaction load to manage performance and scalability effectively.
    • Identify bottlenecks or issues in semaphore queues that may lead to transaction rejections, enabling proactive remediation.
    • Assess database responsiveness and throughput to optimize backend operations.

    These insights empower you to maintain system stability, improve performance, and quickly troubleshoot issues within your ServiceNow instance.

    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.