Captured SQL Query text got truncated in DBAgent. How to increase the captured SQL text size?

[Tiong.Koh]

We have a Microsoft SQL database SP with a few hundred lines. When we tried to analyze the content of this SP under the controller tab Databases|Queries||Query Details|Query, the query text got truncated. Is there a setting can increase the captured SQL text size?

The controller build is  24.6.3.  DBAgent version 23.6.0.0

[MARTINA.MELIANA]

Hi Tiong.Koh,

Thank you for posting to community.

Could you clarify how many characters are currently being captured and how many characters you'd need to be shown? This will help in understanding the scope.

From what I understand, the maximum character of query text shown is hardcoded to the maximum of 32,767 characters in database agent. We can’t change this setting, because, Increasing this limit might lead to higher memory consumption on the DB agent side and increased storage usage on the Controller side.

‌

Regards,

Martina

[Tiong.Koh]

It captured 265 lines with a total of 26,591 characters.  The original sp text size is 38,841. 

[MARTINA.MELIANA]

Hi @Tiong.Koh ,

I apologize for the delay in my response.

I reviewed this limitation and found that an idea request was previously submitted regarding this, but, it was rejected due to concern of system performance. Additionally, the 32,767 character limit was deemed sufficient for SQL analysis at the time.

Regarding the character limit, the current maximum is 32,767 characters, including white spaces.

If this limitation is critical to your business processes, I recommend reaching out to your account manager or sales reps with business justification so that they can discuss with our product manager.

Regards,

Martina

[Ryan.Paredez]

Hi @Tiong.Koh,

Have you had a chance to review the latest reply? If it answers your question, please click the "Accept as Solution" button, if not, reply back to keep the conversation going.