cancel
Showing results for 
Search instead for 
Did you mean: 

Alert and approval message takes long time to appear

Former Member
0 Kudos

Hi,

Our general setting for update message 0 mins. Alerts Management frequency is set to 1 mins. Everything works fine until we upgrade to PL27. Now the alert and approval message sometime takes more than 5 mins to appear. What could be the problem? Any idea how can we check on this?

Thank you.

TWP

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Thanks for your help.

Regards,

Whay Peng

former_member186095
Active Contributor
0 Kudos

You could possibly use SQL server profiler to see what did the alert do when you are opening SBO or using SBO. What version is it ?

Rgds,

Former Member
0 Kudos

Hi Jimmy,

Thanks for the respond. We are using SQL 2000. Shall try this method?

Regards,

TWP

former_member186095
Active Contributor
0 Kudos

Yes. you are correct. As comparison, yesterday I run conversion differences of SBO 2004A and 2005A. It takes 1 hours. I wonder what is the root cause. I checked using profiler and find out that the query is displayed when running SBO. From query I concluded that my currency is the root cause.

When opening SBO 2004A, It is also takes 3-5 minutes, the root cause is the query run in the OALR and many mores.

SQL 2000 has its profiler tools.

Rgds,