Slow SQL issues after migration

Slow SQL issues after migration

  

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? 

  • Rebuild Indexes 
  • Update Statistics

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?


Best regards,

Rafael Valente


Hi Rafael,

For SQL Server:

https://msdn.microsoft.com/en-us/library/ms187348.aspx 

For Oracle:
http://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.


Kind regards,

Ivo Gonçalves


Hello again Ivo,


I'll take a look at what you sent me.

Thank you for your help.


Best regards,

Rafael Valente


Ivo Gonçalves wrote:

Hi Rafael,

For SQL Server:

https://msdn.microsoft.com/en-us/library/ms187348.aspx 

For Oracle:
http://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.


Kind regards,

Ivo Gonçalves


Hello Ivo,


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.


Best regards,

Rafael Valente