IMPORTANT:Review this section only if you installed ZENworks 7 Server Management with Support Pack1
The Server Inventory service might demand high (up to 100%) processor utilization in the following scenarios:
Many Inventory agents are simultaneously upgraded to ZENworks 7 and subsequently, all these agents send the full scans for the time to the Inventory server.
The administrator manually triggers full scan from the Inventory Service object resulting in all Inventory agents send the full scan to the Inventory server.
The Inventory database is either re-installed or changed and then the administrator manually triggers full scan from the Inventory Service object resulting in all Inventory agents sending the full scan to the Inventory server.
The Server Inventory process or other applications are running on the ZENworks server.
The indexes of the Inventory database might have to be recreated.
If the utilization rate is unacceptable, or if the Inventory Storer takes a considerable amount of time to store the inventory data, perform the following tasks to improve the Inventory server performance:
Stop the Inventory Service. For more information, see Section 13.1.4, Starting and Stopping the Inventory Service.
Close all instances of ConsoleOne that are connected to this database.
If your Inventory database is running on Sybase, modify the database indexes using the sybindex utility.
To run the sybindex utility on a NetWare server:
To run the sybindex utility on a Windows server:
NOTE:This execution might take significant amount of time to complete depending on the database size.
If your Inventory database is running MSSQL database, execute the following scripts available in the MSSQL directory of Inventory_server_installation_path\zenworks\inv\server\wminv\ properties\sql.zip with appropriate user logins as explained below from the MS SQL Query Analyzer:
Log in as CIM and execute mssql_perf_cim.sql.
Log in as ZENworks and execute mssql_perf_zenworks.
Log in as ManageWise and execute mssql_perf_managewise.
Log in as MW_DBA and execute mssql_perf_mw_dba.
Ignore any warnings related to DROP statements during the script execution.
Restart the Inventory Service. For more information, see Section 13.1.4, Starting and Stopping the Inventory Service.
Restart the ConsoleOne.
To improve the throughput of the Storer, you can tune the parameters of the service.
Stop the Inventory service. For more information, see Section 13.1.4, Starting and Stopping the Inventory Service.
Run a text editor and navigate to the Inventory_server_installation_path\zenworks\inv\server\wminv\properties directory.
Open the storerdebug.properties file, make the following value change to the uncommented parameter:
filebatchupdate=true
Save the changes and close the file.
Restart the Inventory service. For more information, see Section 13.1.4, Starting and Stopping the Inventory Service.