How do we analyse the slow scripts

[Vishwanath Nair]

I have observed there are several "Flow designer" entries appearing in the "Slow scripts". It doesn't show the actual flow that is causing the problem. How do we analyse which flow is being executed slowly?

[Community Alums]

Hi @Vishwanath Nair ,

That's the expected Behavior !! what you can do is use the Stats Tools adds modules under System Diagnostics > Stats, including Slow Queries, Slow Scripts, and Slow Transactions. 

 Each module accesses a table of activity patterns [sys_query_pattern], [sys_script_pattern], [sys_transaction_pattern]. Each pattern table represents a collection of unique activities. Each collection is an aggregation of executions of that unique activity over all time. Each record provides basic timing analysis with example identifiable details of the activity.

Note: To aid in debugging, you can filter most of these logs by application scope, limiting the transactions (for example, slow scripts or events) to only those transactions originating in specific scopes.

[Vishwanath Nair]

Hi Sandeep,

The screenshot I provided is from the sys_script_pattern table. For other jobs, we are able to see the script source, for example, in the attached screenshot, the source is clearly pointed. But in case of flow designers, even though the SQL query is shown, I am unable to figure out what flow did it generate from. Any idea how we can triage it?

[Sid_Takali]

Hi @Vishwanath Nair Might be this can help you 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0517241 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0814951