Performance counters in SDAC

ninja · Post by **ninja** » Mon 03 Mar 2008 08:10

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?

Antaeus · Post by **Antaeus** » Tue 04 Mar 2008 08:46

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.

ninja · Post by **ninja** » Tue 04 Mar 2008 15:23

DBMonitor is not so flexible and less informative then performance counters. For example, can I monitor the status of connection pool using DBMonitor?

Antaeus · Post by **Antaeus** » Wed 05 Mar 2008 10:57

DBMonitor does not allow monitoring connection pool.

ninja · Post by **ninja** » Wed 05 Mar 2008 16:08

So, is it possible that some useful performance counters will be added to SDAC?

Antaeus · Post by **Antaeus** » Thu 06 Mar 2008 15:47

Could you describe in details, in what situations do you want to use the performance counter, and what parameters you want to monitor.

ninja · Post by **ninja** » Tue 11 Mar 2008 12:31

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.

Antaeus · Post by **Antaeus** » Thu 13 Mar 2008 15:56

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.