System Requirements – Server Side
These are the recommended system requirements for WorkBook.
Requirements are not an one size fits all and depends on the usage pattern of WorkBook. Individual requirements can also be changed/replaced with appropriate or similar hardware.
The user count is for concurrent users online.
| Specifications | 1-20 users | 21-100 users | 101-250 users | 251-500+ users |
| SQL Server | Microsoft SQL Server Express 2019 | Microsoft SQL Server 2019 Standard/Enterprise |
Microsoft SQL Server 2019 Standard/Enterprise | Microsoft SQL Server 2019 Standard/Enterprise |
| Windows server | Microsoft Windows Server 2016 or newer | Microsoft Windows Server 2016 or newer | Microsoft Windows Server 2016 or newer | Microsoft Windows Server 2016 or newer |
| Amount of servers | 1 Server | 1 Server | 1 Web Server 1 Report Server 1 Database Server |
1 Web Server 1 Report Server 1 Database Server |
| IIS | 8.0+ | 8.0+ | 8.0+ | 8.0+ |
| – ASP.NET enabled | Yes | Yes | Yes | Yes |
| .NET framework | 4.6 | 4.6 | 4.6 | 4.6 |
| Windows Azure SDK | Yes | Yes | Yes | Yes |
| Processor | 2.5GHz Quad Core | 2.5GHz Quad Core | SQL Server: 2.5GHz Quad Core Web Server: 2.5GHz Quad Core |
SQL Server: 2.5GHz Quad Core Web Server: 2.5GHz Quad Core |
| Ram | 8 GB | 16 GB | SQL server: 32 GB Web servers: 8 GB |
SQL server: 64 GB Web servers: 8 GB |
| Hard Disk Drives | High Performance SATA or SAS Disks in RAID 1 | High Performance SATA or SAS Disks in RAID 1 | SQL Server: 2 x SSD in RAID 1 or 4 x High Performance Disks in RAID 10
Web Server: 2 x SATA Disks in RAID 1 |
SQL Server: 2 x SSD in RAID 1 or 4 x High Performance Disks in RAID 10
Web Server: 2 x SATA Disks in RAID 1 |
| Hard Disk space (Estimates) | Files on the Database Server: 2 GB Data + 10 GB Log. Growth of approx: 1 GB per year*
Application files on the Web Server: 3 GB + 10 GB Temporary space on the operating system disk. (All of the above is excluding file storage and operating system + applications) |
Files on the Database Server: 5 GB Data + 15 GB Log. Growth of approx: 3 GB per year*
Application files on the Web Server: 3 GB + 10 GB Temporary space on the operating system disk. (All of the above is excluding file storage and operating system + applications) |
Files on the Database Server: 10 GB Data + 20 GB Log. Growth of approx: 5 GB per year*
Application files on the Web Server: 3 GB + 10 GB Temporary space on the operating system disk. (All of the above is excluding file storage and operating system + applications) |
Files on the Database Server: 20 GB Data + 25 GB Log. Growth of approx: 10 GB per year*
Application files on the Web Server: 3 GB + 10 GB Temporary space on the operating system disk. (All of the above is excluding file storage and operating system + applications) |
| Internet Access | Yes, for license renewal, or it can be done manually with 14 days interval. | Yes, for license renewal, or it can be done manually with 14 days interval. | Database Server: No
Web Server: Yes, for license renewal, or it can be done manually with 14 days interval. |
Database Server: No
Web Server: Yes, for license renewal, or it can be done manually with 14 days interval. |
* Hard Disk space is an estimate and can vary depending on the configuration of WorkBook and the amount of data migrated from an previous system.
Additional server requirements regarding on-premises support can be found here.