04-16-2020 09:16 AM
We currently run Act Premium (Web) on a physical Dell server running Windows Server 2016.
Dell PowerEdge R330
Intel Xeon E3-1220 v5 3.0Ghz
2TB 7.2K RPM Sata 6Gbps drives in Raid1
32 GB ram
I want to transition this to run as a Hyper-V VM. The Hyper-V host would be a machine similar to the above with 2 VM's max. We have typically 20-25 people using Act and on average CPU usage is negligible, and RAM usage is about 11GB total with 5.5GB being the Act SQL processes.
This will be the standard Act installation using SQL Express, not SQL Standard.
I'm a little worried about having a VM host with Sata hard drives and not SSDs, but perhaps it doesn't matter with Act if the actual limit to performance is the SQL Express part.
Any insight would be appreciated.
- Version of Act! you are using:
On Windows 10 workstations: Act Premium 22.214.171.124 , Update 4
On Windows 2016 Server: Act Premium Web 126.96.36.199 , Update 4
- If the issue involves Microsoft Office (Outlook, Word , Excel), state the version of Office you are using
- Is your database on your local machine (private database) or is it being shared from a server (shared database)?
Shared from a server.
- Operating system you have Act! installed on (i.e., Windows 7, Windows 8)
Windows 10 1809, 1903, and 1909 on the workstations. Windows Server 2016 on the Act server.
04-20-2020 11:16 AM
04-21-2020 05:55 AM
Hi Mike, thanks for the info.
I will look at 10K SAS or SSD options. What I'm trying to do at the moment is look at our existing disk usage with performance monitor counters. We've toyed around with the idea of doing SQL standard, but have sticker shock, because I believe it would be about $6,000 with CALs.
04-22-2020 07:07 PM