Is there a tool to get the slowests queries ?
Is there a tool to get the slowests queries ?
Comments
You can use the line-by-line monitor to see where the query is spending most of its time.
http://docs.intersystems.com/cache201513/csp/docbook/DocBook.UI.Page.cls?KEY=GCM_monlbl
Thank you
In Cache 2017.1 we have light weight SQL profiling enabled by default which will keep track of the number of times each SQL query is called and how long these queries take. So you can quickly answer the question as to which SQL queries matter to your application and then investigate these important queries in more detail.
This information will show up in the system management portal in the SQL explorer section under the sql queries in this namespace section.
thank you
In 2012.2 and up you can use SQL Runtime Stats to gather the above info plus Global Refs and Lines of Code for every query run. This has more overhead and take up more disk space so please remember to turn this off after you gather the needed info.
If you have questions after reviewing the docs I would be happy to answer them: Brendan@interSystems.com
Thank you