100% CPU Utilization on SQL Server

Document ID:7005283
Creation Date:03-Feb-2010
Modified Date:30-Apr-2012
- Micro Focus Products:
  ZENworks Configuration Management

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2 Database
Microsoft MS SQL server 2005

Situation

100% CPU utilization on MS SQL server.

Entire zone is unresponsive and not usable for end users.

Resolution

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