Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Act! Database Slow - Moved from 2000 to v8

Posted on 2006-11-08
1
Medium Priority
?
267 Views
Last Modified: 2013-11-24
Hi all,

Got a client who was using Act 2000. 11 Users, about 28000 contacts. All running from HP Server (1Gb RAM, Pentium 4, 80Gb IDE Drive, MS Small Business Server 2003) - no problems.

Now, one of the users boyfriends suggested they move to Act version 8 cause it was so much faster and better and he would support it and so forth. Well, its installed, the boyfriend is no longer dating the consultant, the database is horribly SLOW and it now my problem. (sheesh what people will do for a bit of legover...)

Seriously though: Database is now running using the SQL Engine as part of the SBS. The repsonse time on the client pcs is pathetic to say the least. How/where do i start. I've upgraded the RAM in server to 2Gb. The database is running off it own drive. Any more i can do or suggest?

Thanks
Sean
0
Comment
Question by:SeanNij
1 Comment
 
LVL 7

Accepted Solution

by:
SStroz earned 2000 total points
ID: 17909972
Sean,

That's a weird turn of events.  You will be limited in what you can do for them.  ACT! 2006 is much better but utilizes new technologies so old equipment doesn't handle it that well.  ACT! 2000 uses an older architecture and will be much quicker (although limited in functionality) on newer systems.

A few things:
Make sure they're using the most current version 8.0.2 hotfix 5.  (ACT! 2006 is the marketing name)
Upgrade equipment wherever possible.  Shoot for fast processors, 1 MB RAM, and hard drive speeds at least 5400 RPM.

A seperate server would be great.  SBS really uses a lot of RAM for the other processes.  Ideal is a stand alone server for ACT! with 2 GB RAM, good processor, RAID, etc.

Remind the client that SQL scales and is more stable than their old version of ACT! and they have more functionality like Company Records, Opportunity List, Record Security, Export to Excel features, etc.  If they can get past the performance issues they should be able to make more money with this version of ACT!

Good luck

Steve





0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question