Application Insights detail graphs and metrics
Summarize
Summary of Application Insights detail graphs and metrics
Application Insights detail graphs provide node-level views of individual performance metrics in ServiceNow instances. These graphs cover events, ECC queue status, session information, semaphore queues, and database performance. However, starting with the Zurich release, Application Insights is no longer deployed, enhanced, or supported. Customers are advised to transition to the Instance Observer product available in the ServiceNow Impact packages and consult their Account team for assistance.
Show less
Key Metrics and Their Sources
The detail graphs are grouped into three main categories, each sourced from specific tables and keys in the ServiceNow database:
- Events Detail Graphs: Metrics like the number of events processed and logged are sourced from the
sysclusternodestatstable, focusing on processed and logged events keys. - ECC Queue Detail Graphs: These metrics monitor the state of entries (Ready, Processing, Processed) in both input and output ECC queues, with data drawn from the
eccqueuestatsbyeccagenttable. - Session Information Detail Graphs: Provide insights into transaction response times, transaction load, logged-in users, semaphore queue depths, semaphore rejections, and database performance. These metrics come from various keys in the
sysclusternodestatstable and include semaphore and database statistics.
Practical Implications for ServiceNow Customers
- These graphs enable monitoring of instance performance at a granular, node-specific level, helping identify bottlenecks or issues in event processing, ECC queue handling, session transactions, and database responsiveness.
- Understanding semaphore queue depths and rejections can highlight API integration and messaging queue bottlenecks.
- With the deprecation of Application Insights in Zurich, customers should plan to adopt Instance Observer for ongoing performance monitoring, ensuring continued support and feature enhancements.
- Engaging with the ServiceNow Account team is recommended to explore Impact packages and facilitate migration from Application Insights.
The Application Insights detail graphs provide views of individual metrics at the node level.
Starting with the Zurich release, Application Insights is no longer deployed, enhanced, or supported. It is recommended to evaluate the Overview of Instance Observer product available with the ServiceNow Impact packages. Work with your Account team to review Impact packages.
For details, see the Deprecation Process [KB0867184] article in the Now Support Knowledge Base.
| 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 |
| 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 |
| 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. |