Showing results for 
Search instead for 
Do you mean 

Sage ACT! 2011 Premium

New Member
Posts: 17
Country: Canada

Sage ACT! 2011 Premium

I'll be moving to a new server.  It has SQL server 2008 full edition..  Apparently I will "get better performance "?  But I have to pay for a server licence. Will ACT! use this or will it load its version?  Thanks

Copper Elite Contributor
Posts: 405
Country: United States

Re: Sage ACT! 2011 Premium

You can use a full SQL server but it needs to be the right version.


ACT 2011 & ACT 2012 = SQL 2008 R2

ACT 2010 = SQL 2005.


There is a KB article on how to manually create the ACT7 SQL instance. If you do it right, when you install ACT, the installer will automatically connect to and run with it.


Full SQL allows you to use up to 4 processors and all the RAM you can throw at it. The SQL express that comes with ACT is limited to one provessor and 1 GB RAM. The difference in performance depends on the number of users, size of database and the type of operations you do but is very noticeable when you get over 20 or 30 users.


You should know a little about SQL and limit the amount of RAM SQL can take. Being a Microsoft product, SQL is defaulted to no RAM limit and it often takes all of the RAM avaialble which can slow other processes on the server.

Geoffrey B. Boulden
Twelve/Three Marketing, Inc.
Buffalo, NY
SQL Certifications
Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Sage ACT! 2011 Premium

Actually SQL 2008 Standard has a limit of 64GB RAM
SQL Enterprise up to 2TB and Datacentre can go up to the OS limit

You can limit the amount of RAM for the ACT7 instance with ACTDIAG