Solved

Act! Database Slow - Moved from 2000 to v8

Posted on 2006-11-08
1
259 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 500 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now