Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

SQL Server table sizes

Tom Vines September 8, 2022 edited

Hi All,

Our sql database has gotten quite large and on checking the table sizes we've found that the following table AO_544E33_AUDIT_LOG_ENTRY is taking up the majority of the space. 

Currently the JIRA.MBF file size is 32GB and the table size is 20GB.

It lists comms going back to the creation of our Jira instance. 

Can this table be truncated?

Many thanks

Tom

2 answers

1 accepted

4 votes
Answer accepted
Tuncay Senturk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2022

Hi @Tom Vines 

Those tables starting with AO_ are the tables which are used by plugins. As far as I know, AO_544E33 is the prefix for Email this Issue (JETI) plugin.

Since it says AUDIT_LOG, probably it will be ok to back up the table and truncate but I'd clearly recommend checking the plugin's documentation or raising the team a ticket and then moving forward.

I hope it helps!

Tom Vines September 8, 2022 edited

Hi @Tuncay Senturk ,

Thanks for your response.  Yeah found the settings in Email This Issue so need to discuss the time period to keep!

Many thanks

Tom

0 votes
Tom Vines September 8, 2022

Ah this is an feature with Email This Issue

Tuncay Senturk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2022

I think yes, just raise them a ticket and see what they say

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events