I need to test Oracle ERP system module which runs on Linux server and uses oracle as a database. I have some past experience with web performance and load testing however I am not sure whether Visual Studio 2012 is capable of capturing server side performance counters when it comes to linux platform and oracle data base profiling and tracing counters. so following are my questions :<ol><li>Can I capture server specific counters using vs 2012 ?</li> <li>Is VS 2012 capable of oracle sql tracing and profiling ? if Yes than How to set counters for oracle sql tracing and profiling ?</li> </ol>
Thanks in advance...Answer1:
Looks like it doesn't... Created shell scripts and Oracle DBA ascripts to capture the performance counters....Answer2:
It can be done but it is hard work. I have been told of the following method, but do not have any details.
The basic idea is to make the Unix counters visible as Windows Performance counters. Then the Visual Studio Load Test (also
Perfmon) can access those counters just like any other sets of counters. To do this either write your own code or use standard utilities to monitor data within the Unix system and forward it to your code running in a Windows computer. SNMP provides visibility to counters on Unix and so that may be a suitable means of passing the data to the Windows. On the Windows computer your code then transforms the data to your performance counters in Windows.