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
We're trying to set our Confluence installation and administration up in more of a devops capacity. Part of the process is to define KPIs that let us know how well the app is performing. It seems a lot of this data just needs to be pulled directly from the database via SQLs. A lot of the SQLs provided when searching seem to be related to older versions of Confluence. Even the official Atlassian docs at https://confluence.atlassian.com/disc/administration-tips/obtaining-confluence-instance-metrics are woefully out of date. An example is the SQLs referencing the ATTACHMENTS table, but that was removed in 5.7 (I think). Can anyone provide useful SQLs for modern Confluence versions (6.x perferably)? Other methods of gathering statistics are welcome, but I'd like to avoid anything that requires purchasing a plugin for that specific use case. Thanks
Let's break this out into a few different things -
Application Server (Java / DB) Performance:
An application performance monitor like NewRelic or AppDynamics will get you a ton of info about the JVM itself - heap usage, garbage collection stats, etc. in addition to basic info about the host (free/used memory, CPU, etc). It's worth checking one of these out if you're serious about performance monitoring.
Both these tools can check on what SQL queries are being run to give you hints on if there's any plugins running that might be doing things in an unoptimized way. In a previous role as an admin, I was actually able to use the DB performance tools in NewRelic to track down a single misconfigured Confluence macro that was causing an entire Confluence instance to slow down when a particular page loaded.
Confluence (and Jira) come with some stats enabled for export via JMX connector. You enable this in your Confluence config, and then you can attach to the Confluence server stats by running JConsole on your local machine. Check out the document for details on the types of things you can measure with JMX.
etc. - you get the idea!
If there are any specific Confluence-usage stats you're interested in retrieving via SQL, let me know what those are and we can work together on making sure those are 6.x-friendly queries.
We're trying to gather global statistics specific to Confluence itself. I'm familiar with ways to get OS/app/db performance info, but we're being pushed to go even further and provide metrics business stakeholders can relate to. It's also to help us create a history of data to see if we can find any trends or identify issues during irregularities to be notified of issues before users encounter them. A couple of items that come to mind are:
I'm open to any other suggestions as to useful data relevant to the Confluence app specifically. Thanks