CA Service Management

Expand all | Collapse all

SDM WS Integration causes slow performance

  • 1.  SDM WS Integration causes slow performance

    Posted May 16, 2016 05:49 AM

    Hi all,

     

    We have SDM r12.9 conventional architecture integrated with CA SOI. Service Desk has a primary server that does not accepts user/ws connections, several secondary servers and a server fully dedicated for webservices integrations.

     

    Due to our high volume of alerts sometimes we have dozens of tickets opened at the same minute (3 or 4 per second). During this period users experience a huge delay when working with Service Desk.

     

    Last Thursday, and during CA Service Management Office Hours I asked if there is something we can do to prevent this behaviour. Vinod told me to try to increase tomcat memory and maxthread on SDM. He also asked me to put this question on communities so he can share a knowledge document regarding this type of configuration.

     

    Do someone has the same problem as we do?

     

    Thank you in advance.

     

    Pedro



  • 2.  Re: SDM WS Integration causes slow performance



  • 3.  Re: SDM WS Integration causes slow performance

    Posted May 18, 2016 09:34 AM

    Hi Pedro,

    On top of the articles referenced by Jon and understanding that you already have several secondary servers I will  suggest you move to Advanced Availability to take advantage to have the data not passing the background(your current primary) server to commit the data to the mdb.

    I suspect knowing that you already have a dedicated secondary for your WS usage that the primary is your bottom neck here.

    Have a look in the two diagrams in the link below for a quick understanding.

    How to Install CA SDM - CA Service Management - 14.1 - CA Technologies Documentation

    My 2 cents

    /J



  • 4.  Re: SDM WS Integration causes slow performance

    Posted May 19, 2016 01:13 PM

    Thank you both for your contribute on this.

     

    Jon_Israel, documents told me how to do that changes but not on which circunstances it should be done.

    I have a secondary server dedicated to web services. Those changes should take place on that secondary or on primary server?

     

    Do you believe that applying those configurations will decrease performance issues during WS calls from CA SOI? 



  • 5.  Re: SDM WS Integration causes slow performance

    Posted May 19, 2016 02:15 PM

    Hi Pedro,

    If you are going to increase the memory and the threads, then I would recommend doing it to all tomcat instances across all servers. That will help prevent further problems in the future.

    Jon I.



  • 6.  Re: SDM WS Integration causes slow performance

    Posted May 19, 2016 02:39 PM

    yes this must be your first steps prior others actions. starting with the secondary used for your Web services call

    fine tuning tomcat doc can be found here too.

    Fine Tuning Tomcat for better performance

    /J



  • 7.  Re: SDM WS Integration causes slow performance

    Posted May 23, 2016 05:59 AM

    Hi jmayer,

     

    I've increased maxthreads for tomcat regarding http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec598584.aspx.

    What is the best way to test the behaviour on a Quality environment so I can decide if I do the same on Production?

     

    Thank you.



  • 8.  Re: SDM WS Integration causes slow performance

    Posted May 23, 2016 07:24 AM

    Hi,

    This is not much test you can do except if you have a stress testing tool that can simulate the workload of your current production.

    The most important for you is to have regression testing  making sure everything is working as expected after your change but this change is straight forward so you must be clean to go to production assuming you defined your rollout plan that is also straight forward.

    In another words, you can only see positive effect  but will only realize after this is in prod.

    Note that you can just recycle tomcat for this change to take effect without to have to do a full restart of SDM minimizing impact to your users.

    /J



  • 9.  Re: SDM WS Integration causes slow performance

    Posted May 24, 2016 04:41 AM

    Thank you jmayer. I will change maxthreads to 300 today.

     

    Meanwhile I found some articles regarding tomcat fine tuning (not related to Service Desk) and people say that tuning makes all difference in application performance. In my opinion CA should have  better documentation regarding this subject.



  • 10.  Re: SDM WS Integration causes slow performance

    Broadcom Employee
    Posted May 19, 2016 02:12 PM

    Hi Pedro,

     

    If you have such a high volume of web services connections coming into SDM, one of the main thing to keep in mind is the Login time each operation might take.  Especially if you have the web services user's  access type set to External Authentication.  That external authentication dependency is where the bottleneck could be.

     

    One suggestion that could make a huge difference in such a case is,  use PIN authentication for that user (not for all users, just that user.  So you may need to create an access type just for that user), but just the web services . Or use a Policy file.   Using PIN authentication forces SDM to verify the d/b record  and not do any other external checks.

     

    Hope this helps

     

    _R



  • 11.  Re: SDM WS Integration causes slow performance

    Posted May 19, 2016 02:36 PM

    HI,

    I will discourage the use of PIN authentication as tis introduce extra security risk(basic authentication with password stored in clear text).

    Better use a policy key and certifcates for this may you want to avoid external authentication.

    /J



  • 12.  Re: SDM WS Integration causes slow performance

    Posted May 26, 2016 09:32 AM

    We have a lot of integrations in our implementation and have experienced similar issues.   In our case, we found the session log was the culprit.   You have to keep that purged down.  It can really impact performance.    We found that the system was slowing down trying to find an unused session id.    Each login will create a session log record, with a unique session id.    If you accumulate too many rows, the system will bog down trying to establish a session.     Purging down this file immediately relieved the pain point.   

     

    We also identified that some of our processes were written where they would establish a session, perform and action and then disconnect, then establish a session, perform an action and disconnect instead of establishing a session at the beginning of the processing, perform all actions needed and then disconnecting at the end.    This change alone saved the creation of thousands of session log entries every day. 

     

    Hope this helps.



  • 13.  Re: SDM WS Integration causes slow performance

    Posted May 27, 2016 09:31 AM

    Hi AlexisOsborne,

     

    Thank you for your contribution on this.

     

    We don't have active session_log. So I believe that is not our issue. Also, CA SOI creates a unique session and uses it during all processing. Other integrations for WS creates a session, do all the processing and disconnect. I believe this is the right behaviour.



  • 14.  Re: SDM WS Integration causes slow performance

    Posted Jun 01, 2016 09:26 AM

    Hi,

     

    I've increased maxthreads for tomcat but still have problems with mass web services invocation.

    I'm analysing Advanced Availability but I still want to know if anyone has other guess for this problem.

     

    Thank you.



  • 15.  Re: SDM WS Integration causes slow performance

    Broadcom Employee
    Posted Jun 01, 2016 09:31 AM

    Pedro,

     

    From the client side (as in the code initiating your web services call), where do you see the loss of time?  Are you seeing the loss of time when your client is waiting on the connection to be established (ie., BEFORE you get an SID from SDM)?  Or are you seeing serious wait times after you get an SID from SDM?

     

    Thx

    -R



  • 16.  Re: SDM WS Integration causes slow performance

    Posted Jun 01, 2016 10:55 AM

    Raghu, our major issue is regarding performance for users that established a connection to Service Desk via Gui, not Web Services.



  • 17.  Re: SDM WS Integration causes slow performance

    Broadcom Employee
    Posted Jun 01, 2016 10:59 AM

    Is EEM in picture for users who use the GUI? 

     

    Is it via Tomcat or IIS that they access using the GUI?

     

    _R



  • 18.  Re: SDM WS Integration causes slow performance

    Posted Jun 01, 2016 11:21 AM

    We don't use EEM for Service Desk. Authentication is done using ldap.

     

    Users access Service Desk via IIS.



  • 19.  Re: SDM WS Integration causes slow performance

    Broadcom Employee
    Posted Jun 01, 2016 05:36 PM

    I went through the thread back again and it appears that the GUI slowness only happens when web services are hitting SDM. Correct?

     

    If you are opening about 3 or 4 tickets per second through web services,  that's definitely posing an impact on the Domsrvr which handles data access to UI / web services too.   Do you have a separate domsrvr for web services right now?  Its an Options Manager option (that can be installed once you add a new domsrvr).  By default  web services uses default domsrvr that your users use.

     

    Secondly, what type of tickets are these?  Maybe they need a bit more processing time after the ticket is created (example: service types, SLAs etc.,)  which require some more time from SDM.  Maybe that's the component that's sorta slowing things down on the UI aspect.

     

    Do you happen to have a support ticket on this already?

    _R



  • 20.  Re: SDM WS Integration causes slow performance

    Posted Jun 02, 2016 09:11 AM

    Yes Raghu.Rudraraju, you are right. Slowness happens when web services are hitting SDM.

     

    We have a dedicated server for web services but that Options Manager option is not installed (I believe that the domsrvr for Web Services would have to be configured on primary server and I don't want that. Am I wrong?).

     

    I'm talking about Incidents. When created, 3 SLA events (Pre-Warning, Warning and Violation) are associated with it and an email notification is sent to Affected End User and all notifiable technicians from the group where the incident is open.

     

    I didn't open a support ticket regarding this problem. I believe that this is an issue that happens with other clients - discovered that during last CA Service Management Office Hours - and I want to know possible solutions for that.

    Also I don't consider this a bug. A nice to have solution for SDM WS might be some kind of security which prevents more than X invocations for WS from the same user.



  • 21.  Re: SDM WS Integration causes slow performance

    Posted Jun 02, 2016 09:31 AM

    Hi, Note that you can apply restriction of the number of call to webservice using the policy.

    That say this is for all call using that policy not as per user and the threshold is hour)

    Domsvr don'have to be on primary for this the webservice will connect to the domsvr you have listed and this domsvr can be  on your secondary (each one having a unique name)

     

    /J



  • 22.  Re: SDM WS Integration causes slow performance

    Posted Jun 02, 2016 09:40 AM

    Hi Jerome,

     

    Which policy are you talking about? But with the threshold measure at hour probably it will have huge side effects on our monitoring environment.

     

    If does not have to be configured on primary server that might be something to test. Thank you for letting me know.



  • 23.  Re: SDM WS Integration causes slow performance

    Posted Jun 02, 2016 10:12 AM

    This can be configured under the policy table of your web service policy

    administration tab => policies

     

    -1 mean no limit

    you mostly use the default one that is unrestricted.

    I will recommend you to create a specific one for your monitoring tool and use a key if your tools permit.

    advantage to use certificate to authenticate is that this is really more fast and less resource consuming (on top of been more secure) to use vs. going to the full authentication scheme  with OS or EEM.

     

    Hope this help.

    /J



  • 24.  Re: SDM WS Integration causes slow performance

    Posted Jun 09, 2016 03:58 AM

    Thank you. It's better than nothing but is far from the perfect solution.

     

    Yesterday our team had a meeting and we decided to abandon CA's connector between CA SOI and CA SDM. We will create some PAM processes and manage the number of alerts with a queue. That way we will be able to control the number of tickets created at the same time.

     

    Also with this approach, we will be able to pass the right group to incidents since nowadays, and using CA's connector, group is overwritten when we pass Incident Area (that has a responsible group).

     

    What do you guys think about this?



  • 25.  Re: SDM WS Integration causes slow performance

     
    Posted Jun 08, 2016 05:27 PM

    Hi Pedro - Did Jerome's response help answer your question? If so please mark it as Correct Answer. Thanks!