cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

View full database query

Julius_Loman
DynaMight Legend
DynaMight Legend

Currently, there is a limit of 4096 characters for a SQL query (request) in Dynatrace managed. Queries longer than this limit are being truncated in the UI. Unfortunately for some queries in our environment, we even can't see the beginning of the where clause as queries are very long.

Is there any possibility how to either increase this limit (support?) or how to get the full query via other methods than Dynatrace UI? Even marking it as the key request does not bring any possibility to see more than ~4096 characters. I could not find any relevant API call that would allow me to get more information about key service request.


Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner
4 REPLIES 4

Jakub_Mierzewsk
Inactive

In Database Insight limit will be higher ~20k characters. (work in progress) Higher limit for SQLs analyzed from application perspective for key requests seems to be good idea.


harald_berger
Dynatrace Champion
Dynatrace Champion

Please mind that 4096 is a hard limit in the agents. The SQL string is cut off, then a SQL normalization is done. So the resulting string might be even shorter.

Yes, there is a hard limit, but it does not fit all. An 8k or 16k limit would likely solve the issue. Isn't here a DebugUI option to increase the limit for a certain environment?

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

We do not recommend to adapt the limits. It will lead to increaed traffic, load and storage.

Featured Posts