• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by ANOH B. · Nov 20, 2012 at 02:25 AM ·

sqlstmmaxparamlength

Where does the value of sqlstmmaxparamlength come from?

Regards,
Anoh Brou

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Roman S. · Nov 20, 2012 at 04:04 AM

Good question - let me answer that with another question, where have you found or seen it?

A bit more info would be helpful, from the name I can only guess it has something to do with sql statements, parameters and a maximum length.

Best, Roman

Comment

People who like this

0 Show 2 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image ANOH B. · Nov 20, 2012 at 09:47 PM 0
Share

sqlstmmaxparamlength is one of the metrics that can be chosen under CHART ->Add Series -> Create Measure -> Server Side Performance -> Agent Based Measures -> Custom JMX -> Custom JMX Measure -> Browse Metrics -> SqlStmMaxParamLength.

Regards,
Anoh Brou

avatar image Roman S. ANOH B. · Nov 20, 2012 at 10:33 PM 0
Share

JMX (short for Java Management Extensions) is a standard interface used by applications and app servers to provide metrics and operations related to the management of that app/app server. We can capture metrics from JMX through the Java agent (cyclic measure, every 10s).

So the question on what this metric means is best answered by looking at the documentation of the application server or app that you have seen it at. Googling for it I found no hits for the metric you listed above, only hits for SqlStmtMaxParamLength on Oracle connection pools.

Best, Roman

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A