View full database query

[Julius_Loman]

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.

[Jakub_Mierzewsk · Accepted solution]

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]

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.

[Julius_Loman]

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?

[harald_berger]

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