cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

UCCE 8.5.4 Logger -MS SQL consuming virtually all memory

pheadden
Beginner
Beginner

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

2 REPLIES 2

Gergely Szabo
Advocate
Advocate

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
Beginner
Beginner

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 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: