cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
906
Views
0
Helpful
2
Replies
pheadden
Beginner

UCCE 8.5.4 Logger -MS SQL consuming virtually all memory

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

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

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 

Content for Community-Ad

Spotlight Awards 2021