BI 5.x updated to 6.x massive memory usage - AI Related - Max connects

scoob8000

Getting the hang of it
Dec 28, 2018
136
62
PA
I upgraded to 6.0.1.7 after Christmas and noticed my memory blew up. System has 16gb, BI using more than that and hammering my pagefile.

On a whim I disabled the built in AI and went back to CPAI and memory usage went back to normal. However my CPAI seems to be getting hit a lot harder.

I just happened to notice the setting about max concurrent connections to the server, and the help file mentions each connection can use up to 500mb of ram and can overwhelm external servers.
So I'm wondering, how many max connections was 5.x allowing before we had this config option... I took it from the default 40, down to 10 and my CPAI cpu usage went back to normal.
 
Just an update, I dropped the max connects waaaay down to 4 and the memory usage seems decent and didn't increase the response times. Not sure if that was the right move or not but suggested by chatgpt. :)
 
  • Like
Reactions: aesterling