In FSM Server how to find which Business rules have taken more time to execute . We have enable server log for Business rule and exception to 6 as suggested by IFS case to find the performance lag.
But how to find from the server log which business rule taken more time to execute.
What parameter and values need to be checked in the server log.
Best answer by Lee Pinchbeck
Hi
I do not think there is an easy way from the log to determine which rules took longest to complete.
I believe there would be a log entry for the start of the rule and then another entry for the completion so you would need to find these start and stops, work out the difference between the two log times and then compare these values for each rule in the log.
A quicker way would be to run an SQL trace in SQL Server Management Studio as this will allow you to include completed process and these entries in the SQL trace have an elapsed time. You can then sort the trace by elapsed time to see what is taking longest.
Kind regards,
Lee Pinchbeck
+24Hi
I do not think there is an easy way from the log to determine which rules took longest to complete.
I believe there would be a log entry for the start of the rule and then another entry for the completion so you would need to find these start and stops, work out the difference between the two log times and then compare these values for each rule in the log.
A quicker way would be to run an SQL trace in SQL Server Management Studio as this will allow you to include completed process and these entries in the SQL trace have an elapsed time. You can then sort the trace by elapsed time to see what is taking longest.
Kind regards,
Lee Pinchbeck
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
