02-25-2016 01:49 PM
We have an odd issue that popped up.
We have a customer with a dedicated SQL server for Act.
Running SQL Server 2008R2
4 Cpu's 16gb of ram.
Periodically ('m working on determining the routine) the server will continue to chew up memory. Once the memory is maxed out the cpu will go very high as well.
The act service doesn't appear to chew up the memory just sql. any ideas?
02-26-2016 02:06 AM
Have had reports that using the search facility in some configurations can max the SQL.
The following may be helpful.