We use SolarWinds for database performance analysis which just shows the raw SQL executed and often it is very hard to work out where it was called from.
If the platform could insert an SQL comment with the name of the Aggregate/SQL it would be extremely helpful!
We also use Lifetime analytics, but tools like SolarWinds can provide alternative insights.
I've had this issue a few times too, or when you look at deadlocked queries in SQL Server Management Studio or whatever... I can USUALLY find them, but only because I've memorized the whole application, but that's not really effective in most cases... :D
J.Ja
Changed the category to Database
It's very painful to find the query on service studio, from data received from database, or database performance analysis software.
In our case, the DBA send us an SQL generated by an application, to be improved by developers. But its not easy find the espace where the SQL is. We have more than 600 espaces and we spend hours finding each statement.
If the platform add a simple comment in the beginning of each query it sends to the database with that information, we could easily find it.
Example : /* EspaceX - ActionY - QueryNameZ */
Yes, This idea would be helpful as we often face the same problem
That would be a great improvement.
Changed the category to Aggregates & Queries
Hi Neil Munro,
I'm glad to announce that this feature is available on version 10.0.912 and forward.
To enable this capability you need to install the new version of Factory Configuration forge component and check the option "Allow Comment With Query Path". After enable this feature you will have to publish any module that you would like to trace back where in the code the query is located.
This will add a comment on the executed SQL with a breadcrumb of the query location (module -> Service/Server/Screen action).
Thanks for the feedback and hope this fulfill your use case.
Thanks, sounds good. I was about to try this, but wasn't able to find the flag. Turns out that it needs to be on Platform Version 11.0.127.0 for the flag to be visible.
Oh well, time to schedule another Platform update sometime soon then!
Hey Sander,
Which O11 version are you using?
For version O10, it is available on 10.0.912 onward.
For version O11, you are right, it is only available on 11.0.127.0 onward. Sorry for not specifying it!
Regards
Hi Lara,
We recently did upgrade all of our environments to 11.0.108.0, so unfortunately it's not yet available here. Once we do upgrade, we are definitely going to enable it. Sounds very useful!
Kind regards,
Sander
Great to hear you are going to use it!
Let us know your feedback when you have the opportunity to try it.