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
<?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
