Hi all, We are facing an issue where the DB is getting filled up drastically and is causing the IIQ environment to go down. When we check the DB tables, we only see 67% used. Whereas the DB file itself is using 100% of the disk space. Am I missing something? Thanks in advance

@rishavghoshacc Pruning is being done properly in your environment? If yes, check if you have proper hardware configuration using the below article. https://community.sailpoint.com/t5/Other-Documents/IdentityIQ-Hardware-Sizing-Guide/ta-p/79521

hi @rishavghoshacc This usually happens when the tablespace shows free space, but the DB datafile has already grown to fill the disk. So even if tables show ~67% usage, the physical file may be at 100% due to auto‑extend settings. I would do quick checks: Verify if the datafile auto‑extend cause…

Hi @rishavghoshacc , can you check this post? [image] Database FileGroup Size is increasing exponentially IIQ Discussion and Questions Hi @Nitish92 , growing in size is the normal behavior of a DB. In IIQ there are some options which can significantly increase …

Hi @rishavghoshacc You can clear old audit events, task result from your DB Server. Also follow this Post. Database FileGroup Size is increasing exponentially - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

Hi @rishavghoshacc You can clear old audit events and old task results from your DB Server. Also, follow this Post. Database FileGroup Size is increasing exponentially - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community

can you please do these following steps: ->Check the current log level settings and ensure that all loggers are set to INFO level instead of DEBUG or TRACE. Excessive logging can significantly increase database and disk usage. → Review workflows and verify whether tracing is enabled. If any workf…

@rishavghoshacc There could be multiple reasons for this: There are some tables in IIQ whose size grows exponentially like spt_audit_event, spt_syslog, spt_identity_request, spt_identity_request_item, spt_task_result. You can definitely fine tune settings or build few db scripts that help you wit…

@rishavghoshacc I would recommend checking which tables have most volume of data. Also in your log4j2.properties files, please check syslog level. This could be inflating the database.

Hi @rishavghoshacc doing daily counts of the number of rows in the major tables and charting them over time can give useful insight into database space trends. If you post the row counts I’ll see if there are any that look excessive.

IIQ DB running out of space

IdentityIQ (IIQ) IIQ Discussion and Questions

santhirajumunganda (Santhi Raju Munganda ) March 19, 2026, 9:11am 4

Hi @rishavghoshacc , can you check this post?

Topic		Replies	Views
IIQ DB Size not decreasing even after clearing 75% of identities and 75% of provisioning transactions IIQ Discussion and Questions identityiq , provisioning , jdbc-connector	5	177	May 17, 2025
Database FileGroup Size is increasing exponentially IIQ Discussion and Questions identityiq , provisioning	2	280	December 11, 2024
Identity DB Performance Matrix IIQ Discussion and Questions identityiq	4	502	June 10, 2024
Flooding of J Drive on SailPoint IIQ Test SQL Server IIQ Discussion and Questions identityiq , provisioning	1	248	January 4, 2024
IIQ DB Server Log File Drive getting full IIQ Discussion and Questions identityiq	5	864	October 13, 2023

IIQ DB running out of space

Related topics