I have this JQL
project in (CRM) AND issuetype in ("Request For Assistance", Defect, "Customer Defect") AND (Backlog is EMPTY OR Backlog != No) AND status changed to ("Release Pending", Released, Closed) during ("2017-10-09 00:00", "2017-10-15 23:59") and status was in ("Release Pending", Released, Closed) on "2017-10-15 23:59"
It was taking 1-2 seconds few months ago, now it takes 8, we have automation around this query, so having it taking 8 seconds is killing performance and make automation take up to 8 hours to be completed.
Hi Ahmed,
I suppose that your system contains more issues and data than few months ago. Therefore, database queries take more time to return results.
In order to maintain performance, you should consider scaling your system according to the JIRA Sizing Guide (if you already didn't do so), that you can find here:
https://confluence.atlassian.com/enterprise/jira-sizing-guide-461504623.html
You can also find JIRA performance tuning guide:
https://confluence.atlassian.com/jirakb/jira-applications-performance-tuning-229179856.html
and database related knowledge base:
https://confluence.atlassian.com/confkb/database-troubleshooting-180847246.html
Cheers,
Marko
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.