BMC - Slowness observed with a single tenant in a multi-tenant environment
I have a a strange issue. We have a multi-tenant environment with 8-10 tenants. The report performance is good for all the tenants except a single tenant. We did the following test:
Test 1: Detailed report for tenant "Tenant A - TDS" --> Result: Report delivers 193 records and finished in 9 minutes and 15 seconds
Report Filter: Submit Date from 2017-09-01 until 2018-05-31
BMC:SR:2018-05-22 10:52:20:DEBUG (MIReportGeneratorProcess:notifyListeners) - BackgroundRunner: Details: Queued: 10:43:05 -- StartedRunning: 10:43:05 -- Completed: 10:52:20
Repeat Test1 with Filter Submit-Date from 2017-10-01 until 2018-05-31
Result: Report delivers 3 records and finished in 10 seconds
BMC:SR:2018-05-22 10:53:03:DEBUG (MIReportGeneratorProcess:notifyListeners) - BackgroundRunner: Details: Queued: 10:52:53 -- StartedRunning: 10:52:53 -- Completed: 10:53:03
Test 2: Detail report for Client-Organization "Tenant B" --> Result: Report delivered 159 records and finished in 1 seconds
Report Filter: Submit-Date from 2017-01-01 until 2018-05-31
BMC:SR:2018-05-22 11:04:59:DEBUG (MIReportGeneratorProcess:notifyListeners) - BackgroundRunner: Details: Queued: 11:04:58 -- StartedRunning: 11:04:58 -- Completed: 11:04:59
There are no performance problems with YF Client-Organization "TenantB".
Performance of Client-Organization "TenantA" is very poor and depends a lot on the amount of delivered records.
I did check the event and documentdata tables and they have only few thousands record
Do you have any recommendations for me?