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
