11-01-2011 08:38 AM
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
11-01-2011 08:49 AM
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.
11-01-2011 10:26 AM