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
to be clear
I can see the database name within purepath for an application with my existing sensor setup
ADO.NET" agent="MyAgent[MyAgent]@myserver" elapsed_time_ms="98.33465797710232"/>
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
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
August 2017
Announcing Dynatrace's Community Member of the Month for August 2017, Rick B.! Click here to read more! 