UCCE 8.5.4 Logger -MS SQL consuming virtually all memory

[pheadden]

ICM Router/Logger has 4G memory.  sql is using 3.95G of it.  Same issue on both A and B sides.  Has anyone seen this before and how to address.  I can limit the amount of memory allocated to sql but will that impact service.  I'm thinking there is a some random queries in cache that are eating up memory.

Thanks all,

lost in sql space

[Gergely Szabo]

Hi,
do you have a database lookup node in your ICM script?
Did you try to run the SQL profiler to check for suspicious queries?
Also, can you check the CPU consumption of the SQL server process.
G.

Sent from Cisco Technical Support iPad App

[sunil suthar]

were you able to find a resolution. I have the same issue

UCCE 8.5.4 

Roggers have around 95% memory utilzation, with SQL process consuming 90% of the memory. we are running the ova template of 4GB with less than 4k agents