Environment
Novell ZENworks Configuration Management 11.x
Microsoft SQL Server (MSSQL) database
Situation
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.
Resolution
Set a min server memory and max server memory for the MSSQL
database by following this Microsoft document:
Cause
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.