How much space do I need to run the NetIQ GroomArchiveDataDetail task?
You must have sufficient available hard drive or spindle space to generate two temporary tables which will each be roughly the same size as the ArchiveData Table in the AppManager repository. You can determine how much space will be needed for these two temporary tables by running the following query in SQL Query Analyzer against the repository:
exec sp_spaceused archivedata
The resulting data returned will have several columns, some with numerical values. Add the values of the data and index_size columns to get the kilobyte value of how much space is currently being consumed by the ArchiveData table. Allow twice as much space in free disk or spindle space to guarantee the successful completion of the NetIQ GroomArchiveDataDetail Task.
If insufficient space is available on the hard disk or spindle being used to host the repository's MBD file, the NetIQ GroomArchiveDataDetail Task may fail, hang, or run indefinitely.
The NetIQ GroomArchiveDataDetail Task generates two temporary tables based off of the contents of the ArchiveData table.
The task uses these tables to preserve collected data points while stripping the XML formatting from those data points. This process preservces any new data that is written to the ArchiveData table after the first temporary table was generated.
The task then completes this process by running a ShrinkDatabase function against the ArchiveData table in order to remove any unused or "white" space from the ArchiveData table.