Community
Showing results for 
Search instead for 
Do you mean 
Reply

Improving Act 2012 performance

Accepted Solution Solved
New Member
Posts: 4
Country: USA
Accepted Solution

Improving Act 2012 performance

We're running Act on a VM running Windows Server 2008 R2. The VM has 6 GB RAM, is running on a host on a 10 GbE backbone connecting to desktops at 1 Gb. Storage is to a FC SAN. The storage array contains 7200 RPM SATA, 10 K SAS and Flash drives. At the moment, the "C" or system drive and the data drives are FC with auto tiering moving some of the data to Flash.

 

Does anyone know whether Act would be faster if the system and data were moved implicitly to Flash?

 

More a matter of curiousity before I start screwing around with reconfiguration.


Accepted Solutions
Solution
Accepted by topic author barryc@theedison.com
‎10-26-2015 07:05 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Improving Act 2012 performance

Even with a limited number of users you can see a performance improvement with SQL standard, especially with larger databases due to SQL standard being limited to memory usage and single processor usage.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Improving Act 2012 performance

Where is the SQL server located?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 4
Country: USA

Re: Improving Act 2012 performance

We're running SQL Server express on the same VM. At some point, when we upgrade to a newer version, we'll probably move to full edition of SQL Server, but with so few active users - less than 10 - we've not been motivated to do that so far.

Solution
Accepted by topic author barryc@theedison.com
‎10-26-2015 07:05 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Improving Act 2012 performance

Even with a limited number of users you can see a performance improvement with SQL standard, especially with larger databases due to SQL standard being limited to memory usage and single processor usage.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 4
Country: USA

Re: Improving Act 2012 performance

Thanks,

 

That is as expected.

 

I'll look for how to migrate to the full server.

 

Thanks

 

Barry