I'm tuning performance for SAS Financial Management. Our FM database contains 2 cycles (day and month), many formulas (calculated in memory) and duplicated data over different analyses. Many data loads/extracts are performed. Yesterday, the system performed around 60 uploads to the FM database. Also, many data is exported out of the FM database. This is very resource demanding! We've already scaled the available memory (125 GB) between different web application servers and tuned the servers together with SAS support. Still we face regular hungs and shutdowns for SASServer3 and SASServer4. I hope this can give you an idea of the actual workload.You can find the gc logging for SASServer3 in attachment.
... View more
