CA Service Management

  • 1.  Measuring DB Agent numbers for CA SDM 14.1

    Posted Sep 16, 2016 09:44 AM

    Hi All,

     

         Is there any way to measure the DB Agents required for CA SDM. Our SDM is getting slow some times.

    So we don't have idea exactly what value to set in NX.env file for MAX_DB_AGENT and MIN_DB_AGENT. Currently it is set to 25.

     

    Regards,

    Vikash



  • 2.  Re: Measuring DB Agent numbers for CA SDM 14.1
    Best Answer

    Posted Sep 16, 2016 01:36 PM

    Hi Vikash,

    This all depends on your environment - is it Conventional (Primary/Secondary) or Advanced Availability (Background, Standby App servers)?   In conventional, only the primary talks to the db, but in advanced availability, all the servers talk to the db independently.  If you are in a conventional setup, during a time when you feel the system is a bit slow, you can run the command pdm_vdbinfo on your primary server and pipe it out to a file (pdm_vdbinfo > vdbinfo.txt).  The output will include the following:

     

    C:\Users\Administrator>pdm_vdbinfo
    ========================================
    VDBINFO invoked at 09/16/2016 13:28:14
    ========================================
    Min Config Agents = 6
    Max Config Agents = 6
    Max DB Agents = 6
    Tgt num idle = 2
    Num Agents running = 20
    Num Agents starting = 0
    Num Requests pending = 0
    Actual num idle = 2

     

    What you want to look for is the "Actual number idle" - which if you ever see that its "0" then there are no dbagents available.    The vdbinfo will also show you queued requests that are in a wait state as well, so if there are a lot of those, that is also a telltale sign.

     

    Now, with all that in mind, performance issues can be casued by a large number of different factors, not just dbagents.  So if you are having a noticeable slowdown in the product performance, you should open a support case and one of our engineers will look into the problem with you to pinpoint the cause.  We have also created a tec document that is published which gives you some things to look at as well - you can find that document here: CA Service Desk Manager Performance Problems - Quick Checklist 

     

    Hope this helps,

    Thanks,

    Jon I.



  • 3.  Re: Measuring DB Agent numbers for CA SDM 14.1

    Posted Sep 22, 2016 07:04 AM

    Thank you Jon for you reply and time.

    I have one query out of your suggestion - Can we have the command pdm_vdbinfo in advance availability also. We are using advance availability r14.1.

     

    Regards,

    Vikash



  • 4.  Re: Measuring DB Agent numbers for CA SDM 14.1

    Posted Sep 22, 2016 07:07 AM

    Oh yes,

    Sorry. Got it. It is running in advance availability also. :-)