1.1 On-Premise Deployment Recommendations
1.2 Azure Deployment Recommendations
1.2.1 Recommended Azure VM Series
General Purpose: D-series (Dv3, Dv4, Dv5) are well-suited for balanced CPU and memory workloads, such as SQL Server for business applications.
Memory Optimized: The E-series (Ev3, Ev4, Ev5) offers higher memory-to-core ratios, ideal for memory-intensive databases.
1.2.2 Specific Azure VM Sizes
Disk: Use Premium SSD managed disks. For SQL Server, use at least two P30 (1TB) disks: one for data/tempdb, one for logs.
OS: Select Windows Server 2019 or 2022 for best compatibility and support.
SQL Server: You can deploy SQL Server as an image from the Azure Marketplace or install your licensed version.
1.2.3 Notes
If you have more than 10 users or expect higher workloads, consider scaling up to 8 vCPUs and 32GB RAM (D8s_v5 or E8s_v5).
For most business database workloads, D4s_v5 or E4s_v5 will provide excellent performance and future scalability.
Always use Premium SSDs for SQL Server data and log disks for optimal I/O.
Follow Microsoft’s SQL Server on Azure VM guidelines: separate data and log disks, enable read caching where appropriate.
For cost-effective development or light workloads, start with DS2_v2 (2 vCPUs, 7GB RAM) and scale up as needed.
Azure SQL Databases are not supported as they lack cross-database processing and the Common Language Runtime.
It's important to note that these are minimum requirements, and the actual system requirements may vary depending on the size of the database, the number of users, and the specific features and functions being used.
3.1 All-in-One Server Recommendation
Hardware: CPU of i3/5/7 or Xeon, 16GB RAM, 200GB Hard Disk space, preferably with 2 hard disks in a RAID-1 (disk mirroring) setting.
Windows Server License Required: Windows Server of the latest or 2nd latest version (64-bit)
SQL Server License Required: Microsoft SQL Server Express or Standard Edition of the latest or 2nd latest version
3.2 Three Separate Servers (Best Performance)
1. Database Server
Processor: 2GHz
Memory: 8GB
Hard Disk space: 100GB - 200GB
2. Application Server (for Web Client)
Processor: 2GHz
Memory: 8GB
Hard Disk space: min. 100GB
3. Application Server (for Employee Portal)
Processor: 2GHz
Memory: 8GB
Hard Disk space: min. 100GB
SQL Server with the HRPro database installed and accessible by the Employee Portal Server.
Operating System: 32-bit/64-bit Microsoft Windows Server 2012 Standard or Enterprise Edition with Service Pack 2 or later.
Web Server: Microsoft IIS 6.0 or later.
Supported Browsers: The two latest released versions of Chrome, Edge, Firefox, and Safari.
Microsoft .NET Framework 4.7.2 or above (included in Windows Server 2019 or above).
ASP.NET.
An SMTP server is required for email integration.
Running IIS on the domain controller is not recommended.
If the Employee Portal is opened to the Internet, proper network infrastructure and security controls are required.
See also