DX Application Performance Management

  • 1.  Database Backend show 2 items (System and SID)

    Posted Mar 07, 2016 07:15 PM

    Dears,

     

    in Backends I got 2 item one start with System and the other start with the SID as shown bellow:

    can some explain what is the difference between both items:

     

    BR



  • 2.  Re: Database Backend show 2 items (System and SID)
    Best Answer

    Posted Mar 07, 2016 07:25 PM

    Hi,

    System **** on port 1521 metrics indicate we only see a Socket call going outside the JVM which otherwise is not detected as a backend call by SQL Agent.

    This could happen in a scenario for e.g when there is some application code that is making a socket call to Oracle backend using code that is not probed\monitored out of the box with SQL Agent extension or if database driver is uncertified.

    This thread might also help:

    Backend "System" Calls in Investigator

     

    Regards,

    Kulbir.



  • 3.  Re: Database Backend show 2 items (System and SID)

    Posted Mar 08, 2016 02:51 PM

    Does anyone know what this outgoing socket call is / does?

    It appears to me that all the Oracle backend looks similar to that dual connection shown in that picture: once socket + one with SQL.



  • 4.  Re: Database Backend show 2 items (System and SID)

    Broadcom Employee
    Posted Mar 08, 2016 03:20 PM

    Hi Fred:

    Kulbir's link answers your question

     

    The former "System OracleServerX on port XXXX" is from the socket tracer and the latter "oracledb OracleServerX-XXXX (Oracle D")" is  from the SQL agent tracer, both of which are instrumented as backends. Statements to the database which are not detected by our SQL instrumentation will be caught by the Socket Tracer and reported as System on port X.



  • 5.  Re: Database Backend show 2 items (System and SID)

    Posted Mar 08, 2016 03:27 PM

    I wanted to ask this question for years would you have some examples what those non-detected statement could be?



  • 6.  Re: Database Backend show 2 items (System and SID)

    Posted Mar 08, 2016 04:41 PM

    Fred,

    If there is good amount of activity for the Socket backend then just run a transaction trace and that should give you further clue as to what application\database code might be making this call which is not being detected by SQL Agent.

     

    Regards,

    Kulbir.



  • 7.  Re: Database Backend show 2 items (System and SID)

    Posted Mar 08, 2016 05:02 PM

    ah, so we are not talking about some strange non-SQL queries, but transactions that are rapid and not traced. Maybe those Select from Dual ...



  • 8.  Re: Database Backend show 2 items (System and SID)

    Broadcom Employee
    Posted Mar 08, 2016 08:12 AM

    Hi:

      Please let us know if Kulbir's answer was helpful. Or if there are additional questions

     

    Thanks

    Hal German