Community
Showing results for 
Search instead for 
Do you mean 
Reply

[Act2012 Premium] Universal Search Problem

Bronze Elite Contributor
Posts: 2,518
Country: USA

Re: [Act2012 Premium] Universal Search Problem

The logs are showing 3 second intervals. Can you send a new log? Also can you collect CPU properties like orginally with a 24 hour period?

 

 

Copper Contributor
Posts: 153
Country: Belgium

Re: [Act2012 Premium] Universal Search Problem

We've re-enabled the Act.Server.Host service for another 24 hours with logging enabled.

 

You can find the log file here

Do note that at 11:30 PM the SQL Service is brought down for back-up, at 5AM it's re-enabled.

 

The process properties after 24 hours:

 

We've also noticed that the spikes in RAM (and CPU) happen every time someone attaches something in Act (file, e-mail, shortcut). Outside of office hours (when no-one is working in Act), the spikes aren't happening.

 

Hope you can help us with this,

 

Kind regards

 

Europower Generators

Copper Contributor
Posts: 153
Country: Belgium

Re: [Act2012 Premium] Universal Search Problem

Any news/info on this?
Bronze Elite Contributor
Posts: 2,518
Country: USA

Re: [Act2012 Premium] Universal Search Problem

I believe this is functioning as expected. I'm not seeing any critical problems here. Can you help me understand the negative impact?

 

"We've also noticed that the spikes in RAM (and CPU) happen every time someone attaches something in Act (file, e-mail, shortcut). Outside of office hours (when no-one is working in Act), the spikes aren't happening."

 

The Search service will add each attached file to the index. This means reading the contents the email and indexing each word. Depending on the file type and size this will take differnent amounts of time, but it's a very fast process. 

 

The Search index is set to poll for changes every 3 seconds. making is a very fast process. If you are willing to only search for things that were attached yesterday or earlier we could modify the reindex update interval to 24 hours instead of 3 seconds. This would prevent the service from running during the day, push that function of reindexing to the night, but it would mean that no daily activities get added to search results until that evening. 

 

The search service process is set to Low priority which means all other CPU activity take precendent. 

Copper Contributor
Posts: 153
Country: Belgium

Re: [Act2012 Premium] Universal Search Problem

Well the negative impact is basically that during these spikes, a lot of actions in Act take much longer to complete. With usually around 20 people actively working in Act at the same time, attaching files and the like, this is not a pleasant situation. I guess with smaller databases, less attachments this would be a non-issue though.

Modifying the reindex update interval might be what we need to do, I'm guessing it's:
indexUpdateInterval="3" -> indexUpdateInterval="86400"

Also, could it be that the 460 000+ files in our attachments folder are making attaching files slower?

We often get complaints from users (we have been getting them for years actually) that attaching files often takes 15 or more seconds, even after our server update to a machine with ssd's in raid1, so we're guessing it's something client sided. When we use Sysinternals Process Monitor to check what Act is doing at the time, it seems to not be doing much at the time, except for accessing the Attachments folder that is.

Going there using Explorer isn't pleasant either, Windows Explorer does not take kindly to a few hundred thousand files being in one folder.
Bronze Elite Contributor
Posts: 2,518
Country: USA

Re: [Act2012 Premium] Universal Search Problem

If end task on the Act.Server.Host.exe, do the performance problems go away?

Copper Contributor
Posts: 153
Country: Belgium

Re: [Act2012 Premium] Universal Search Problem

Well ofcourse, as soon as we stop the service, the spikes stop happening and performance is decent again.

Bronze Elite Contributor
Posts: 2,518
Country: USA

Re: [Act2012 Premium] Universal Search Problem

Let's try modifying the service index interval to 86400. (24 hours)

 

And setting a task to restart it once a night. Make a batch file and have it run as a scheduled Windows task. 

 

taskkill /im Act.Server.Host.exe /f

"C:\Program Files (x86)\ACT\Act for Windows\Act.Server.Host.exe"

 

May be a slightly different path. 

 

Would you be willing to provide us with your attachments folder and database for evalutation?

Copper Contributor
Posts: 153
Country: Belgium

Re: [Act2012 Premium] Universal Search Problem


@benjamin wrote:

 

Would you be willing to provide us with your attachments folder and database for evalutation?



We'll have to discuss that with our boss. If we decide to upload it, we need to find somewhere to upload 60GB to, which might not be very easy to find.

 

We changed the config value to update the index once every 24 hours as you suggested, we will keep you updated.

New Member
Posts: 1
Country: United_Kingdom

Re: [Act2012 Premium] Universal Search Problem

Hi,

 

We are experiencing a similar issue with one of our client's databases.

 

Our customer is running SBS 2011 and the server (although capable enough) is being crippled by excessive disk activity during what seems to be the re-indexing process. As our client can send large quantities of email at times during any normal day we are having complaints of Act seemingly crashing and becoming unusable on a regular basis, whilst also seeing high R/W activity on the hard drive(s) maintaining the SQL.

 

Our problems seem very similar to those mentioned by Europower and we too have a large attachement folder currently at 49GB with upwards of 142,000 files which is increasing daily.

 

We will be disabling the act.server.host.exe service this evening and scheduling in the task as detailed above and will feedback our findings if this is of any use. The company are happy to provide backups and/or access to the site/server to a Sage tech if this would help in resolution as their loyalty to the product is diminishing quickly.

 

Will