10
 Followers
54
 Likes

Reverse tracking SQL

Aggregates & Queries
New

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
Comments (8)

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


views
484
Followers
10