Slow database performance with Asset Management queries

  • 7008356
  • 12-Apr-2011
  • 30-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Inventory
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Database
Novell ZENworks 11 Configuration Management - ZCM 11 Database

Situation

Very slow database performance/utilization, with Asset Management queries.

Database query is not using correct join option.

High CPU utilization when running Asset management reports.

Resolution

For ZCM 11:  This is fixed in version 11.1 - see KB 7008746 "ZENworks Configuration Management 11.1 - update information and list of fixes" which can be found at https://www.novell.com/support

For ZCM 10.3.4:  This is fixed in version 10.3.4 - see KB 7008244 "ZENworks Configuration Management 10.3.4 - update information and list of fixes" which can be found at https://www.novell.com/support

Additional Information

 Root Cause:

A cartesian join is missing when joining LC_COMPONENT and NC_WORKSTATION tables.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.