Hello community,
After doing a migration from version 8 to 9.1 on diferente machines, my application server started to act a lot less efficient while accessing the database (Outsystems database, therefore not external database) through some queries. I runned the same queries on SQL Server and things run smoothly. What can be causing this to happen?
Best regards,
Rafael Valente
Hi Rafael,
Have you executed maintenance plans on the database after the upgrade?
Kind regards,
Ivo Gonçalves
Hello Ivo,
First of all, thank yuo for your reply.
I'm going to run a maintenance plan this weekend so i can improve the performance of the database access.
When you say "Update Statistics", what exatcly are you refering to?
For SQL Server:
https://msdn.microsoft.com/en-us/library/ms187348.aspx
For Oracle:https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#i37048
For SQL Server you have to run the update manually. For Oracle it is automatic unless you changed the default setup.
Ivo Gonçalves wrote:
I already ran the maintenance plan rebuilding indexes and updating statistics but still i get a lot of SLOW SQL logs. What more can i do to prevent this to happen?
Thank you in advance.
Hello again Ivo,
I'll take a look at what you sent me.
Thank you for your help.