09-11-2016 09:31 PM - edited 09-11-2016 09:32 PM
We have a customer who has been using Act! for a long time, They have upgraded a number of times but they seem to always be having the same issues. Most of the issues are around activities and high memory use, customer has a large number of activities.
They are currently using Act! 18.2 (APFW) but they are having the issues from the desktop version. They have 3 users and are in a Citrix environment . We sent the database to database repairs before the upgrade to see if there were any issues with the database before upgrading. Did not find any issues.
They are on Windows Server 2008R2 Standard with 12GB of memory and a Xeon processor. they are using SQL Standard 2014. Not using any customisation or addons
I have run all the DB repairs from Actdiag did not make a difference.
Something I did notice is when an activity is created, they will add notes to the Details of the activity, sometimes copying the content from an email which might have an image. While they are progressing with the customer they will move the activity to the next meeting and add more notes. they do this so they can easily review all of the notes related with this activity, Could this be causing large memory use issues? they have around 9000+ activities in total.
reschedule an activity and see the following error ( added some information into the details of the activity and move the date of the activity to the next meeting date and press OK, will see the following error and Act!.exe is using a large amount of memory.
Click to look at the calendar and has no entries. Pressing F5 to refresh does not bring back the activities. Have to close Act! and reopen for the activities to display again.
09-12-2016 04:25 AM
09-12-2016 05:43 PM - edited 09-12-2016 09:38 PM
Database size from ActDiag is 1.5GB (1531.75MB). Having image files in the database will this cause high memory usage in the Act!.exe? Is there a quick to clear images that are existing in the database?
As the customer was navigating around activities I was watching the Act!.exe memory usage and it increased very quickly. another use was already really high.
09-13-2016 01:59 AM
09-14-2016 09:50 PM
I have taken a backup copy of their Act! and restored for testing (without attachments). I removed old data.
Which removed 8733 cleared activities. I noted that before I removed the cleared activities memory usage is about 900MB of memory. After removing the old cleared activities memory usage was about 630MB, When you use this method of removing cleared activities are the attachments untouched?
09-16-2016 02:41 AM