Database performance degrades over time

  • 7007239
  • 22-Nov-2010
  • 07-Jun-2013

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Patch Management

Situation

Database performance reduces over time
 
Table PatchScanAuditLog has millions of rows

Resolution

In ZENworks 11 there a new feature that let one set how many days to keep data starting at 1 day to 360.  Or one can disable completely by setting it to 0 days.   See ZCC Configuration > Patch Management > Dashboard and Trending
 
Workaround:  for ZENworks 10.3.0, 10.3.1 and 10.3.2:
 
If there are millions of rows in the table PatchScanAuditLog , it may be necessary to manually delete the data in the table. To do this, execute the following SQL query on the database (Oracle, SQL Server or Sybase):
  truncate table PatchScanAuditLog;

IMPORTANT: Deleting or truncating tables (depending on database platform) with over a million entries can take some time and resources from business activities. To avoid any unexpected behavior, run these queries after doing a complete backup of the database. Additionally, queries should be run during off-peak hours at a time when all primary server services can be shut down.
 
If the database is on MS SQL server, it is recommended to then shrink the database file after the truncate has taken place, in order to free up any unused disk space. On Sybase this can be accomplished with dbunload (See section ' 35.1.1 Rebuilding the Sybase Database' of the ZENworks 10 Configuration Management System Administration Reference documentation).