10-16-2015 02:12 PM
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.
10-22-2015 08:23 AM
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.
10-16-2015 02:43 PM
Where is the SQL server located?
10-19-2015 06:13 AM
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.
10-22-2015 08:23 AM
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.
10-22-2015 08:34 AM
Thanks,
That is as expected.
I'll look for how to migrate to the full server.
Thanks
Barry