Identifying slow integration queries
Import
·
Mar 07, 2022
·
article
Do you need to find details about slow queries coming from inbound integration calls to APIs? Below are three tables that can serve as a starting point:
| Table | Filter using | Relevant fields |
|---|---|---|
| Slow queries (sys_query_pattern) | Example Java stack trace starts with API_INT API_INT indicates an API call was made. | Example URL This field displays the API call made, for example: /api/now/table/incident state=1 category=Software Average execution time (ms) |
| Transactions (syslog_transaction) | Type = REST Created by = [The integration user used by the other application to authenticate] | URL This field displays the API call made, for example: /api/now/table/incident?state=1&category=Software Response time |
| Log (syslog) | Level = Warning Message starts with Cancelling transaction(For transactions that exceed the maximum REST Table API transaction quota rule [default = 60 sec]) | Message Contains the API call made. |
View original source
https://www.servicenow.com/community/now-platform-articles/identifying-slow-integration-queries/ta-p/2306796