Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advice for virtualizing a physical Act Premium server

Highlighted
Astute Commentator
Posts: 37
Country: USA

Advice for virtualizing a physical Act Premium server

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 21.1.187.0 , Update 4

On Windows 2016 Server:  Act Premium Web 21.1.187.0 , Update 4

 

- If the issue involves Microsoft Office (Outlook, Word , Excel), state the version of Office you are using

Office 2016

 

- 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.

Highlighted
Platinum Elite Contributor
Posts: 14,732
Country: Australia

Re: Advice for virtualizing a physical Act Premium server

The HDD speed can affect performance. If possible, go with 10K or (better) 15K RPM.
Around 20-25 users, I would start looking at SQL Standard to access more RAM
Highlighted
Astute Commentator
Posts: 37
Country: USA

Re: Advice for virtualizing a physical Act Premium server

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.

Highlighted
Platinum Elite Contributor
Posts: 14,732
Country: Australia

Re: Advice for virtualizing a physical Act Premium server

The SQL cost is less per core: SQL 2017 Standard 2-pack of Core Licenses
$3,717 ($1,859 per core)
https://www.servermania.com/kb/articles/sql-server-cost/

But your drive subsystem is still the most important place to invest the cash.