04-23-2013 08:54 AM
We are in the process of replacing our server and upgrading our network. Currently the server is 7 years old and Act crawls on it. What are the best practices to achievce optimal speed when building from the ground up. Unfortunately we have 10/100 switches and it will be that way for a while, does that have the most impact on this? The new server is going to be a Dell R520 dual processor unit with about 32gb of ram. We have about 15 users with about 30k in contacts. Can someone please shed some insight so i can get the most speed out of this.
04-23-2013 10:25 AM
04-23-2013 11:19 AM
at 30 users, you can benefit from SQL Standard. Fast hard drives help, more processor helps, more Ram helps. You're wise to get exchange off that server, it will chew up your resources.
04-23-2013 04:36 PM
04-23-2013 11:28 PM
The respondents have offered good advice.
The other aspect is the database itself. If you don't regularly run Database Maintenace you ought to schedule that to run every day.You could take a look at archiving the database and removing old data, you can do both from the database maintenance menu in ACT! Tools. If you have an old version of ACT! it would pay to upgrade to get the benefit of speed improvements in later versions of ACT!. In considering a new server, SSD drives are a good choice as a SQL database is I/O intensive.