Essbase ASO retrieve
On-Prem Essbase 126.96.36.199.014
Windows 2012 Environment
Essbase ASO database with 1.5GB dat file, 1.5GB pending cache size.
At times, simple retrieves from this ASO database which usually take less than 10 secs run for about 20mins or higher and we end up with stuck threads on the APS side (cluster of 3 managed servers) in WebLogic. When users realize the request is taking lot longer, they simply close Excel and re-launch it with a new session, which further adds to the problem. We see around 50 concurrent retrieve requests in EAS.
Are there any settings or other intricate stuff that we need to be focusing on to be able to figure out a root cause? Appreciate any and all your help.