Improving Act 2012 performance

[barryc@theedison.com]

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.

[Roy_Laudenslager · Accepted solution]

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]

Where is the SQL server located?

[barryc@theedison.com]

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.

[Roy_Laudenslager · Accepted solution]

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.

[barryc@theedison.com]

Thanks,

That is as expected.

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

Thanks

Barry