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
Solved
How is the process to purge ODX Databases
+1Best answer by bas.hopstaken
Hi
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.
+4Hi
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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
