nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Server table sizes

Tom Vines

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

Accepted answers

Tuncay Senturk _Snapbytes_

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!

All comments

Tuncay Senturk _Snapbytes_

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

Ah this is an feature with Email This Issue

Tuncay Senturk _Snapbytes_

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

Tom Vines

Hi @Tuncay Senturk _Snapbytes_ ,

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

Many thanks

Tom

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

ms-sql