Performance counters for dotConnect
Posted: Tue 01 Oct 2013 07:07
Hi
We have previously used the performance counters available with System.Data.OracleClient (http://msdn.microsoft.com/en-us/library/ms254503.aspx) to monitor application db performance in "the wild" at customers, back when we used the stock provider.
Now we have changed to dotConnect for Oracle and we need the same thing again. However as far as i can tell there is no such thing for the dotConnect providers (I might be wrong, if so please point me in the right direction).
We can get some of the way by using dbMonitor but is not very pratical to have to sit and monitor output from it, and likewise we need to write tools to parse the data.
If we had performance counters, the gathering could be done in the background and we could use all the existing tools to handle/visualize the data.
Is adding performance counters, on par with the ones in (http://msdn.microsoft.com/en-us/library/ms254503.aspx), on the todo list?
We have previously used the performance counters available with System.Data.OracleClient (http://msdn.microsoft.com/en-us/library/ms254503.aspx) to monitor application db performance in "the wild" at customers, back when we used the stock provider.
Now we have changed to dotConnect for Oracle and we need the same thing again. However as far as i can tell there is no such thing for the dotConnect providers (I might be wrong, if so please point me in the right direction).
We can get some of the way by using dbMonitor but is not very pratical to have to sit and monitor output from it, and likewise we need to write tools to parse the data.
If we had performance counters, the gathering could be done in the background and we could use all the existing tools to handle/visualize the data.
Is adding performance counters, on par with the ones in (http://msdn.microsoft.com/en-us/library/ms254503.aspx), on the todo list?