• 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 David N. · Feb 14, 2013 at 06:13 PM ·

Cannot see sql stored procs in DB dashboards

Hello,

When viewing the Database Dashboard and looking at the response times of used sql queries, we are only able to see selects and inserts while we have stored proc's that are being run also.

There is one stored proc that does show up for some reason but all of the rest do not show up.

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 Andreas G. · Feb 15, 2013 at 06:33 PM

We should not make a difference between "regular" SQL and stored procedures. I wonder though if your Stored Procedure calls are made in transactions that you do not get a PurePath for.
So - let me ask you this: do you have a PurePath that shows the code execution where you expect the Stored Procs to be called but dont see them?

What we often see with other applications is that there are background worker threads that execute database statements. By default you dont get a PurePath for these transactions as they are not initiated by a Web Service or HTTP Request. Make sure that you see these transactions - then check again if you also get to see these Stored Proc calls.
In case you do have transactions like that you need to define your own custom Entry Point Sensors that will start new PurePaths for your background jobs

Andi

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 David N. · Feb 21, 2013 at 03:51 PM 0
Share

There are background threads but these are purely clean up procs and things like that. All of the stored procs we are looking for have been initiated by a web service call.

avatar image Andreas G. ♦ David N. · Feb 21, 2013 at 05:58 PM 0
Share

If this is a test environment you could try to set the JDBC sensor to "active and start PurePath". then see whether you get to see all these SQL Calls. If you get to see them after that change it means that these SQL Calls are not made on a transaction that is currently captured by a PurePath.

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