Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT SQL Memory/CPU Issues

New Member
Posts: 2
Country: USA

ACT SQL Memory/CPU Issues

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?

 

 

Bronze Elite Contributor
Posts: 1,427
Country: United_Kingdom

Re: ACT SQL Memory/CPU Issues

Have had reports that using the search facility in some configurations can max the SQL.

 

The following may be helpful.

 

http://kb.act.com/app/answers/detail/a_id/25582/~/how-to-manage-act!-and-sql-server%C2%AE-memory-usa...

New Member
Posts: 2
Country: USA

Re: ACT SQL Memory/CPU Issues

We've tried that option. it still maxes out the memory. We don't know the SA password either so we can't access the sql server directly to check the settings.