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?
Have you executed maintenance plans on the database after the upgrade?
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:
For SQL Server you have to run the update manually. For Oracle it is automatic unless you changed the default setup.
Hello again Ivo,
I'll take a look at what you sent me.
Thank you for your help.
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.