Back to Ideas
54
Like
Follow Idea
Reverse tracking SQL
2952Views
13Comments
Implemented
Aggregates & Queries
Platform Server 10.0.912.0

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.

23 May 2018
Copy link to comment

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

24 May 2018
Copy link to comment
Changed the category to
Database
25 May 2018
Copy link to comment
Merged this idea with 'Add comment on Queries with espace and action to easily find them in Service Studio' (created on 12 Jul 2018 16:02:56 by Diogo Nesbitt)
14 Jul 2018
Copy link to comment

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 */ 



Merged from 'Add comment on Queries with espace and action to easily find them in Service Studio' (idea created on 12 Jul 2018 16:02:56 by Diogo Nesbitt), on 14 Jul 2018 14:18:29 by Justin James
12 Jul 2018
Copy link to comment

Yes, This idea would be helpful as we often face the same problem



Merged from 'Add comment on Queries with espace and action to easily find them in Service Studio' (idea created on 12 Jul 2018 16:02:56 by Diogo Nesbitt), on 14 Jul 2018 14:18:29 by Justin James
13 Jul 2018
Copy link to comment

That would be a great improvement. 



Merged from 'Add comment on Queries with espace and action to easily find them in Service Studio' (idea created on 12 Jul 2018 16:02:56 by Diogo Nesbitt), on 14 Jul 2018 14:18:29 by Justin James
13 Jul 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Aggregates & Queries


Merged from 'Add comment on Queries with espace and action to easily find them in Service Studio' (idea created on 12 Jul 2018 16:02:56 by Diogo Nesbitt), on 14 Jul 2018 14:18:29 by Justin James
13 Jul 2018
Copy link to comment
Changed the category to
Aggregates & Queries
25 Nov 2018
Copy link to comment
Changed the status to
Implemented
on 07 Jan 2019

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.

09 Jan 2019
Copy link to comment

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!


29 Jan 2019
Copy link to comment
2018-05-30 09-45-58
Lara Luís

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

31 Jan 2019
Copy link to comment

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

31 Jan 2019
Copy link to comment
2018-05-30 09-45-58
Lara Luís

Great to hear you are going to use it!

Let us know your feedback when you have the opportunity to try it.


Regards

31 Jan 2019
Copy link to comment