Freeing Up Disk Space in Database for Enterprise Analyzer Workspace

Freeing Up Disk Space in Database for Enterprise Analyzer Workspace

Problem:

Client was verifying workspace and noticed that database server was running out of disk space.  Client is wondering if it is possible to free up disk space in the database.  Client is using SQL Server.

Resolution:

These steps will also apply to Oracle workspaces.

In most cases, the database should automatically grow to enable more free space for the workspace's database.  In cases where free space is needed, client can perform several options.  Enterprise Analyzer Administration contains tools that can free up disk space by deleting several tables that may not be needed.

Under the Tools menu in EA Administration, the following options can help.

  • Purge Activity Log
  • Shrink MSSQL Database - this shrinks the database files.  Your DBA can also choose to shrink the actual database tables directly.
  • Metrics History - Delete Metrics History.  This option deletes Metrics history that is used for trending data.

If you are planning on re-verifying the workspace, selecting Administer - Invalidate Workspace will truncate full tables, rather than the selective invalidation through the browser which would only delete specific rows.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2017-10-16 17:17
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.