Zone performance is slow with MSSQL database

  • 7014907
  • 14-Apr-2014
  • 14-Apr-2014


Novell ZENworks Configuration Management 11.x
Microsoft SQL Server (MSSQL) database


Devices take a long time to refresh and the ZENworks Control Center is very slow.

The CPU utilization on the MSSQL database server is low, but the memory utilization is high.


Set a min server memory and max server memory for the MSSQL database by following this Microsoft document:


By default, if those settings are not set, the MSSQL database will consume more and more memory until it is using all of the memory. Rebooting the server will temporarily take the memory usage down, but it will slowly take it over again. This is not a memory leak, but as designed by Microsoft.