Skip to main content
Question

IAM database growing alot in physical size how to reduce

  • February 16, 2026
  • 1 reply
  • 6 views
A
Forum|alt.badge.img+3

Hi community 

 

I have a problem where my IAM database is getting big and I require some guidance on shrinking its size. 

Ive found the quilty tables and have reduced the logging to a smaller time frame so it should clean itself better in the future. 

How would i go about removing these existing records?
Through IAM or is there no other way then usting some SQL queries. 

Ive also found out that just removing rows might not be sufficient and to actually reclaim space on the disk a shrink command would have to be used. Is there any risk associated with doing that?

Kind regards

Anne Vries
 

1 reply

E
Moderator

Shrinking a database causes severe index fragmentation and is something that should be avoided unless absolutely necessary, after a large one-time only delete action. So a shrink is best performed outside business hours with a index rebuild right after.

Also make sure to leave some space left since a database always grows, leaving 20% empty space is a good rule of thumb. 

    Terms & ConditionsCookie settingsAccessibility statement