Slowest Queries or Resource Extensive Queries
Whenever your database is facing any performance issue or resource scarcity,
the first step should be finding the culprits.
I mean finding the slowest or most resource consuming queries and usually
10% queries are responsible for 90% of problems. You can use this very simple
query to get the list of those scripts and start your work to