Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can you upgrade MS SQL 2008 R2 Express to MS SQL 2008 R2 Standard for Act! 2012 Pro?

Highlighted
New Member
Posts: 7
Country: USA

Re: Can you upgrade MS SQL 2008 R2 Express to MS SQL 2008 R2 Standard for Act! 2012 Pro?

Yes, the original use case is a slow start up time on client workstations. We migrated from Act 6 directly to Act 2012 Pro and went from a few seconds to about 2 minutes to start up the program on client workstations attached to a server via local network. I did all the tweaking with network infrastructure (NICs, hubs, switches, etc) and tuned the startup time on workstations to be very close to start up time on server itself.

 

I'm currently experiencing about 50-60 seconds to open Act Pro 2012 on MS Server 2008 R2 after fresh server reboot. The time goers down to about 35 seconds for the subsequent server program startups, I'm assuming this is due to hard drives caching being turned on. 

 

The size of backed up database (ZIP file) is 4.8 GB, the size of SQL database reported by Act! Diagnostic is 166.88 (assuming this is in MB?) There are about 1,400 records in database with the complete history for many records (notes and attachments). We are in highly regulated business and need to keep the client notes. We also use adds-on product called Act4Advisors version 3.5. The database is re-indexed once per week using Act! Scheduler.

 

The Start Up view is already set to Contacts. The goal is to start up the program as fast as possible. I hope this helps.

 

Jake

 

Highlighted
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Can you upgrade MS SQL 2008 R2 Express to MS SQL 2008 R2 Standard for Act! 2012 Pro?

You are correct, the SQL database is in MB (166.88 mb) which tells us you have a lot of attachments (since backup is 4.8gb).

 

Since you are addressing the startup time, here are some things to do:

On the server:

- Open the demo database.  This will provide a baseline timing.

 

On a work station:

- If you do not use Sage E-marketing/Swiftpage:

   - close Sage ACT!

   - Browse to C:\Program Files\ACT\Act for Windows\plugins

   - Rename files: 'actspe2005.dll' and 2 files that begin with 'keyoti.rapidspell' (add .old to the end)

   - Open Sage ACT! to test

 

- To see if the internet links on the Welcome screen are causing the delay:

   - close Sage ACT!
   - Browse to C:\Program Files\ACT\Act for Windows\

   - Rename folder 'Home' (add '- old' to end)

   - Open Sage ACT! to test

 

If these steps help, repeat them on additional workstations.  If these 2 options do not help, the files can be renamed back to original.

 

Greg Martin
Sage
Highlighted
New Member
Posts: 7
Country: USA

Re: Can you upgrade MS SQL 2008 R2 Express to MS SQL 2008 R2 Standard for Act! 2012 Pro?

To open a demo database on the server takes 12 seconds.

 

Disabling Sage E-marketing/Swiftpage adds-on resulted in the following improvements:

 - Workstation 1 (with SSD drive):   Before - 30 seconds / After - 13 seconds

 - Workstation 2 (with reg. HD): Before - 50 seconds / After - 35 seconds

 

Renaming Home folder had no impact on the start up speed.

 

Great help, thank you!

 

Jake

 

 

Highlighted
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Can you upgrade MS SQL 2008 R2 Express to MS SQL 2008 R2 Standard for Act! 2012 Pro?

Glad to hear it helped. And Thank You for posting the update!
Greg Martin
Sage