Hello, we've had 4 cases open with Atlassian over the last 2 years regarding slow re-index times. The slowness was intermittent at first where sometimes we could 'lock Jira and re-index' successfully in 16 minutes, and other times taking around 5-6 hours. It has become more regular, and after all of the performance logs and SQL logging everything always looks fine with the Jira app. The slowness comes from the DB. Recently, our DBA discovered if he clears the 'processor cache' or 'plan cache' then Jira will all of the sudden become fast again. The problem is, you almost have to run this command on the DB every few minutes, because it will become slow again 20 minutes later. The command in Microsoft SQL he is executing is "DBCC FREEPROCCACHE"
Has anyone seen this - any ideas for a permanent solution?
I've always known reindexing to take hours not minutes. I have about a 7gb database right now - I can reindex locked in 4 hours. I typically though do a regular index that allows access that will run 5-6 hours on a Friday night, when I need to.
I'm on SQL 2014.
In my experience the time it takes to index is most effected by the number of issues and the number of custom fields in your environment. I'm not sure I understand why this SQL command would improve performance here, but honestly, I'm suspicious as to what other side-effects the frequent use of this SQL command might cause.
Could you tell us more about your environment? Specifically I'd like to know:
There are two different ways to gather all this information accurately from Jira.
With this information, I would be interested to then learn more about the hardware for both Jira and the SQL server to better understand if your system is meeting the expected hardware requirements.
Hello, thank you for taking the time to respond.
MS SQL 2014
321 custom fields
The DB server hosts a few other DBs for our other Atlassian products, but that's it.
The Jira server hosts Jira only.
We thought we may have something by following this VMWare article. But, not totally sure this has resolved anything...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot