What BSA version are you using here also?
Hi, 8.9 SP1
Is your DB Oracle or SQL Server?
Are you seeing the problem with Smart Groups and Static Folders? Or just one of them?
DB is Oracle. The problem seems mostly around static groups in the Depot and Job workspace. Sometimes the non BLAdmin user will be navigating and all of a sudden the console stops responding.
I would go ahead and log a support case if you have not already done so.
The best troubleshooting approach for this is:
1) Ask the DBA to configure the BSA DB to allow for 15-minute interval AWR, ADDM and ASH reports
2) Login to your BSA console at the start of a 15 minute period (2:00, 2:15, 2:45 etc) and reproduce the issue by navigating through the groups until you observe the issue.
3) When complete, ask the DBA to generate and send the AWR, ADDM and ASH for the 15 minute period during which you reproduced the issue
4) We will review the DB reports to see which SQL Queries were responsible for the lag during this time.
The reason we are doing 15 minute reports here is, if you include the data for a full hour, the DB queries from the UI actions tend to get lost when compared to the DB queries from running Jobs etc
Thanks for the help John we'll follow the above and submit a support ticket.