How to Retrieve the data displayed in the Jira Database Monitoring page
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Jira provides a view of its database connection usage via the Administration (
) > System > Database monitoring page. This provides information on the activity of the connection pool, as well as the frequency of reads/writes to the database.
This data is persisted in /$JIRA_HOME/monitor directory via the open-source rrd4j utility.
Environment
Jira 7+
Diagnosis
Jira administrators can retrieve the physical files from the /$JIRA_HOME/monitor directory to aid with troubleshooting and investigation if needed especially when the Administration (
) > System > Database monitoring page is unavailable for some reason. The following files should be available in the directory:
ConnectionPoolGraph.rrd4jDatabaseReadWritesGraph.rrd4j
Solution
The files can be copied over from one Jira instance (Jira A) to another (Jira B) to view their contents.
Go to the
/$JIRA_HOME/monitordirectory of the originating Jira instance (Jira A).Copy the files over to another target Jira instance's
/$JIRA_HOME/monitordirectory (Jira B).Restart the target Jira instance (Jira B)
Go to the Administration (
) > System > Database monitoring page of the target Jira instance (Jira B) to view the contents.
Was this helpful?