08-22-2016 04:29 PM
Hi, users from time-to-time experience slow perfomance saving and opening a campaign within MA. There are ample of space (grid), CPU, and the datasource traffic looks to be very light.
Do notice the LDAP server is low on space. Could this impact the overall MA performance?
08-23-2016 09:47 AM
CIS is run inside of a JVM. Are you looking at the statistics of the JVM? The Server's O/S may show everything as ok but the JVM is it's own container with a dedicated amount of resources.
We had an issue with performance which we attributed to low heap space in the JVM. In the CIS Admin Guide (pg 219) there is be a reference to the Java parameter -Xmx. After a couple of times of increasing that value we have not experience frequent slowdowns. If I recall right we doubled the value 2 times. (ex: original -Xmx2gb 2nd try -Xmx4gb -Xmx 8gb).
Hope that helps.
08-23-2016 10:36 AM - edited 08-23-2016 10:37 AM
I agree that 2GB is probably not enough, but do be a little cautious with increasing the max heap size too much, as you might experience some intermittent performance hits when garbage collection occurs. We try to keep it to no more then 8GB, and only go that high if 6GB isn't sufficient. You might also want to increase -Xms at the same time so you don't have performance issues when new memory needs to be allocated.
The other thing that can cause seemingly simple things to intermittently take a long time is if you don't have enough load balanced connections defined on the Stored Process Server that's supporting MA (if you have just one, it's SASApp, but depending on your installation, you might have more than one and could have a "SASCI" or "SASAMA", etc. server context). The out-of-the-box configuration includes 3 that are configured to handle multiple concurrent jobs, but we like to re-configure that to have ~20-30 that handle just one job at a time, which avoids short jobs getting queued up behind longer-running ones. Check out http://support.sas.com/kb/40/567.html for more details, and contact email@example.com if you have questions about this.
08-23-2016 10:54 AM
- increase the memory and max number of connections for the JVM on SASServer1 (your SCS) and the SASServer of MA/MO and restart the middle tier.
- increase the number of load balanced STPs and restart the Object Spawner.
Additionally, I have seen, specially on MA/MO solutions, and because UTF-8 is working on the SASApp, you may have additional activity on your Database, just querying but really doing nothing. You might want to review the activity on your database. This should not happen, but I actually saw this surprisingly happening after a migration from CI 5 to 6, and using a different database engine.
As said, not necessarily your case, but who knows.
If you find this to happens, I strongly recommend you to get aligned with your best DBA expert and SAS Technical Support.
08-23-2016 02:19 PM
Hi All, thanks for all the replies. Would the issue show up in any of the log files? The Production team would need to have definitive 'evidence' that is the root cause in order to make the change in Production.
Our DBA did pull stats on the DB side, looks pretty clean.
08-23-2016 02:27 PM
08-23-2016 03:24 PM
@pcapazzi - we have it installed but not configured (SAS PS is coming to do that), so when there are error pages everywhere within the app.
Did you have an attachment, doesn't look like it came thru.