Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
09-30-2024 08:03 PM
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
10-01-2024 08:09 PM
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
10-02-2024 07:00 AM
It captured 265 lines with a total of 26,591 characters. The original sp text size is 38,841.
10-07-2024 06:05 PM - edited 10-07-2024 06:06 PM
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
10-10-2024 10:27 AM
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.
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form