Skip to main content

Good morning Team,

The database [ODX_COL_PROD] has 2.0 TB of data, and we need tu purge it.

Can someone give or send me informacion/documentation about the purge data task.

Thanks for your help.

Ignacio

 

Hi @ignacio
 

You can try the built-in report in SQL Server to see the disk space per table and find out which tables use the most disk space. To do this, open SQL Server Management Studio, right-click the ODX database, select Reports, Standard Reports, and finally Disk Usage by Top Tables.

If you do full loads in the ODX, a new version of a table is created for each load. You can manage this by using the Storage Management Task to set the maximum number of versions that need to be saved.

After cleaning the ODX using the Storage Management Task, you can shrink the database file to release the hard disk space. To do this, open SQL Server Management Studio, right-click the ODX database, select Tasks, Shrink, Files, and finally OK. 


Reply