0

I'm using the DevArt dotConnect for Oracle performance counters in my dev/test environment. By adding Use Performance Monitor=True to my database connection string, I can capture useful information such as number of connections, etc.

enter image description here

However, on my production box, I cannot see the DevArt performance counters in Resource Monitor:

enter image description here

I believe that the performance counters are installed, since they appear in the registry:

enter image description here

...and I imagine that adding Use Performance Monitor=True to my database connection string would cause an error if the relevant DLLs etc. were not present.

What else do I need to do to make the performance counters appear in Resource Monitor?

Gary McGill
  • 26,400
  • 25
  • 118
  • 202
  • What is the difference between your developer and production environment? Make sure you run the application for the first time with administrator rights. (It creates "Devart dotConnect for Oracle" counter section). Make sure you still pass "Use Performance Monitor=True;" in the connection string on your production environment. – Devart Jan 28 '22 at 14:06
  • @Devart: when you say "*make sure you run the application for the first time with administrator rights*", what application are you referring to? The application I'm monitoring (a website)? Does this then install the performance counters globally? If so, can I run *another* application with a different user account (but still with admin rights) to get the counters installed, and then use them with my website (assuming I also modify the connection string for that application)? – Gary McGill Jan 28 '22 at 16:05
  • 1
    Yes, it must be enough to run once another application with administrator rights, which opens Oracle Connection and contains "Use Performance Monitor=True;" in the connection string. – Devart Jan 31 '22 at 11:12
  • @Devart: I was finally able to arrange this on our production server (I created a dummy application that simply connects to the database with `Use Performance Monitor=True` in the connection string, and ran that application under my administrator account). It made no difference. Even after rebooting the server, the DevArt performance counters are still not available in Performance Monitor. – Gary McGill Feb 07 '22 at 20:10
  • @Devart: Note that the counters appear to be set up in the registry at `HKLM\SYSTEM\CurrentControlSet\Services\Devart dotConnect for Oracle\Performance` *but* they are not listed in `HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009\Counter` (which they are on my Dev/Test box). – Gary McGill Feb 07 '22 at 20:11
  • @Devart: what can I try next? – Gary McGill Feb 07 '22 at 20:12
  • We still don't know: what is the difference between your developer and production environment? Typically the "Devart dotConnect for Oracle" Performance Counters shall appear after the first run of the application which opens Oracle Connection and contains "Use Performance Monitor=True;" in the connection string (and has necessary permissions). We don't see different behavior in our environment. Probably the problem does not apply to the connector itself and is related to some local settings in your production environment. – Devart Feb 10 '22 at 10:54

0 Answers0