Skip to main content
Question

Performance Issues with SLA Script Execution During Upgrade from APP9 to APP10UPD16

  • September 13, 2023
  • 0 replies
  • 19 views

Laklani
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 2 replies

Hi,

 

The customer is upgrading from APP9 to APP10UPD16 and we have been experiencing a massive slowness in the execution of the script POST_SLA_DataUpgrade.sql which is now running for over 7 hours and counting (upgrade is still ongoing). In previous upgrade iterations in the same server, the script has executed in under 2 hours. There is also an increase of around 50000 work orders in the latest data set used. Has anyone else experienced this during recent upgrades? Any performance tuning or known causes for such a slow execution?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings