• 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 Quinten l. · Nov 20, 2013 at 09:21 AM · business transaction

How to determine sql executions per database name via System.Data

I would like to create a BT that traps the number of executions against per database name via the SQL Connection.

 

We have a multitude of databases and I wish to trace which applications hit which databases and how many times.

 

I have created the sensors to trap the class methods for

System.Data.ProviderBase.DbConnectionPool

System.Data.SqlClient.SqlConnection

System.Data.SqlClient.SqlConnectionString

I created a measure based on the argument value of a DbConnectionPool.GetConnection specifying the database name as the argument value (as a "contains" with eval as occurence)

However, when I create the BT based on this measure I get hits from applications that have purepaths that do not touch that database

Please will anyone be able to enlighten me as to what I am doing wrong?

Many thanks

Lucas

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 Quinten l. · Nov 20, 2013 at 11:18 AM

to be clear

I can see the database name within purepath for an application with my existing sensor setup

<?xml version="1.0" encoding="utf-8"?><purepath_execution_tree><nodeinfo level="6" method="GetConnection(DbConnection)" error_type="" argument="MyDataBase" exec_total_ms="0.017259214539080858" breakdown="CPU Total: 0.017 ms, Sync Total: 0 ms, Wait Total: 0 ms, Suspension Total: 0 ms" class="DbConnectionPool" api="Connection Pooling, ADO.NET" agent="MyAgent[MyAgent]@myserver" elapsed_time_ms="98.33465797710232"/></purepath_execution_tree>

 

I just dont seem to be able to create a BT that will catch just a specific database using that argument value ie. argument="MyDataBase"

 

 

 

Any ideas?

many thx

Comment

People who like this

0 Show 0 · 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.

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

1 Person is following this question.

avatar image

Related Questions

Violation count metric in Incident

How to capture the user details who executed a servlet or webrequest in a java application hooked up with APPMON?

Best way to have a meaningful "Database time" stoplight

Page SLA Pass - Fail BT

Splitting only shows <...> in live session

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