10
 Followers
54
 Likes

Reverse tracking SQL

Aggregates & Queries
Implemented
on 07 Jan 2019
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.

Created on 23 May 2018
Comments (13)

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


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)

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

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

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

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

Changed the category to Aggregates & Queries


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.

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.


Regards

views
1070
Followers
10