SQLs for a Performance Issue

Community ForumCategory: DatabaseSQLs for a Performance Issue
matheusdba Staff asked 1 month ago

“Do we have any set of SQL queries that we need to run during performance issue?”

1 Answers
matheusdba Staff answered 1 month ago

Of course there, but if there was only a single path of queries don’t you think all the performance issues in the world would be fixed already?
Each problem needs to be investigated individually and addressed accordingly. Even on the layer: Is is the database that is slow, or a specific query?
Assuing it’s a session/SQL, the only think I can say generally to you is “if it’s slow, check what is the event on the session (consistently, more often) and start from there. The vent is the most valuable information in general.