URL field on syslog_transaction table

[helga]

Hi:

I am trying to identify a performance issue on my instance. I believe the issue is due to slow-running Business Rules. I am trying to identify the execution of the Business Rules on the syslog_transaction table. I see that there quite a few records on that table with really long transaction times (in the ballpark of what the users are complaining about, over 30 seconds), and which have values on the "URL" field like "/sys_script.do?sys_id=<actual sysid>".

But I am unsure as to what these rows represent. Are they executions of the Business Rules themselves? Or are they only recording instances where the definition of the BR has been loaded in the ServiceNow GUI? From the documentation, I tend to think that the second option is the right one, but I'm seeing very long times on the table which do not match my experience when loading the BR definition form.

Any help / clarification would be very welcome.

HQC

[rajeevlochan82]

It shows the operation performed like opening a form, List , Soap Transaction. The type field in the record shows the type of operation being performed. Unfortunately it does not show individual break down of script execution

at the bottom of forms list , you do get idea of response time Response Time Indicator - ServiceNow Wiki

which provides you some indicator.

If you append your service Now instance name in front of "URL" field   then it will take you to actualt operation your were performing

[sergiu_panaite]

Hello Helga,

As admin you can go to System Diagnostics -> Stats -> Slow Scripts and if there are slow business rules they will be mentioned there.

[helga]

Sergiu:

Thanks for pointing this out. I will certainly look into it. However, I am still unclear about the meaning of the URL field on syslog_transaction when its value is /sys_script.do?sys_is=....

Does such a row mean that:

1.- The definition of the business rule with the specified sys_id was loaded on the Business Rule definition form (but the rule itself did not actually run).

OR

2.- The business rule with the specified sys_id was executed because its conditions were met.

Regards

HQC

[JC Moller]

Hi,

One way to locate slow business rules is by doing a search to the localhostlog data.

Every time a business rule execution takes more than 100 ms, a "Slow business rule name of the rule and execution time" row is written to the log.

Open System Logs > Node Log File Browser. Select start and end time for the query. Give Slow business rule as the search string in the message field.

You can also add a user's Session Id, to narrow down the search. Note that this searches the application node that you are currently logged onto.

You can then browse the list and try to locate any Business rules that run for longer than expected.

- Jan