You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello, I am a Confluence administrator from Ford. We are having serious issues on Confluence and at moments things are not doing well. Very slow and our DBs had to kill several SQL queries to clean up the performance issues.
Our DB team identifies the following issues:
1) Why Select statement and Delete running at the same time on the content table
2) why too many sessions triggered at the same time, around 500 sessions were there today
3) what triggers all these sessions - Job or user interface?
Also, we have 8 CPUs running on the DB server and we used to have MS SQL Max Degree of Parallelism set to 0 and then we changed to 1 but it didn't fix the issue. I am still having performance issues.
Please we have more than 5000 users worldwide and we can't go like this. Please here is my email firstname.lastname@example.org
It would be nice we can see a meeting with my team talk about all these issue.
I'm going to assume the headline question is the case - "Confluence has performance issues"
The reason I want to do that is that the body of your question has instantly moved way past just "it's slow" straight into blaming the way Confluence is using the database, when you don't actually know that that is the actual problem.
What makes you think it is the database?
I'm not saying it is not, but the three questions you're asking have skipped past all the diagnostics you should be doing, and are not going to help you with the details. You don't really know that it's related to any of those things (not from what you've said here). They are things to look at, certainly, but they could be a problem because something else is wrong, leading to these issues. You might be asking about symptoms, not causes.
Confluence (and indeed any Atlassian or even Java application) performance is a complex field, and you're unlikely to get the Community to go over the hundreds of things it could be and hope there is a simple answer. There's very little chance that there is a single smoking gun someone can identify without a very detailed rummage through your system.
I think you'll probably want to go to Atlassian or their Partners. If I were you, I would
If you start with an Atlassian call, start at https://support.atlassian.com/contact, or use the "raise support call" within the admin options in your Confluence.
Please note, I've tried to write all of that as an independent Community member who has had some experience in the field of performance on Atlassian applications. But I want to be very clear that I also work for one of the partners that you might engage (and, at the moment, if you did end up with us, it would probably be my team - we're looking at 5 Jiras, a Confluence and a Bitbucket for various clients at the moment!)
Thanks for posting to the Community. Since this is a production issue I would suggest submitting a support issue to Atlassian here https://support.atlassian.com/contact/
Performance issues in Confluence can be caused by a myriad of issues. If you are now having issues I would ask what have you recently changed on your instance? Have you upgraded? Updated an app? Installed a new app? Looking here first can help you quickly identify the issue.
Also, have you taken a look at the Confluence logs? What are you seeing there? Are there errors or other warnings you are seeing in a large number in the application logs?
Are you only seeing the issue during work hours when all the users are on or are you seeing it in the evenings when a limited number of users is on?
just as an additional information for posterity and because this topic still comes up with Confluence administrators I'd like to add a more general link to performance tuning guidelines for Confluence: