Page 1 of 1

Performance counters in SDAC

Posted: Mon 03 Mar 2008 08:10
by ninja
As I can see there is no windows performance counters available in SDAC. It would be very usefull to have performance counters in SDAC like in ADO.NET to monitor the status of the application. Do you have in plans adding performance counters?

Posted: Tue 04 Mar 2008 08:46
by Antaeus
Try using our DBMonitor tool. It lets you tracing queries that are currently executing, and view information about already executed queries (their status, duration, etc.). DBMonitor is a freeware tool, you can download it at this page.

Posted: Tue 04 Mar 2008 15:23
by ninja
DBMonitor is not so flexible and less informative then performance counters. For example, can I monitor the status of connection pool using DBMonitor?

Posted: Wed 05 Mar 2008 10:57
by Antaeus
DBMonitor does not allow monitoring connection pool.

Posted: Wed 05 Mar 2008 16:08
by ninja
So, is it possible that some useful performance counters will be added to SDAC?

Posted: Thu 06 Mar 2008 15:47
by Antaeus
Could you describe in details, in what situations do you want to use the performance counter, and what parameters you want to monitor.

Posted: Tue 11 Mar 2008 12:31
by ninja
I want to use SDAC performance counters to monitor the status of my application and the connection resources that it uses on production machine (not development or staging). Performance counters can be monitored by using Windows Performance Monitor or can be accessed programmatically. For more detailed list of performance parameters you can refer to ADO.NET performance counters description in MSDN. I believe Core Lab development team can provide much more useful (S)DAC specific counters that can assist in solving performance issues on machines without development environment.

Posted: Thu 13 Mar 2008 15:56
by Antaeus
Thank you for information. We will consider possibility to add something like this to SDAC, and probably to other our DAC products. But it will unlikely to happen in the near future.