SQL Server
Patriot uses industry standard Microsoft SQL Server. This ensures reliable and consistent database performance for the smallest to very largest Patriot systems. Patriot is used with SQL 2014+.
Note that Microsoft SQL Server is not included in the Patriot package pricing and should be sourced from a preferred Microsoft supplier.
Patriot Lite / Professional < 2000 Accounts | SQL Express |
Patriot Professional / Enterprise < 10,000 Accounts | SQL Server Standard |
Patriot Enterprise 10,000 - 100,000 Accounts | SQL Server Standard / Enterprise (Enterprise is generally not required) |
Patriot Enterprise 100,000+ Accounts | SQL Server Standard / Enterprise |
Typical Hardware Specifications
Signal Concurrency module is recommended over 25,0000 accounts
Patriot Workstation Client computer – all Monitoring Stations
Processor | Intel Pentium or AMD. Multi Core Recommended |
RAM | 8GB Minimum |
Hard Disk | SATA/SSD 80GB or greater |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows 10 Professional 32/64 Bit |
Patriot Server computers (no SQL installed) - all monitoring stations
Processor | Intel Pentium or AMD. Multi Core Recommended. |
RAM | 8GB Minimum |
Hard Disk | SATA/SSD 80GB or greater |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows 10 Professional 64 Bit (Windows Server 2012, 2012 R2, 2016, or 2019 supported) |
USB | USB 3.0 / USC-C |
Patriot Server computer - Less than 2000 Clients
Processor | Intel Pentium or AMD. Multi Core Recommended. |
RAM | 8GB Minimum |
Hard Disk | SATA/SSD 160GB or greater |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows 10 Professional 64 Bit (Windows Server 2012, 2012 R2, 2016, or 2019 supported) |
USB | USB 3.0 / USC-C |
Patriot Server Computer – Up to 10,000 Clients
Processor | Intel Xeon or AMD Equivalent. Multi Core. |
RAM | 16GB Minimum |
Hard Disk | SATA/SSD/SAS See SQL Server system setup document for more details. |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows Server 2012, 2012 R2, 2016, or 2019 64 Bit |
USB | USB 3.0 / USC-C |
Patriot Server Computer – Up to 100,000 Clients
Processor | Intel Xeon or AMD Equivalent. Multi Core 4 core minimum. |
RAM | 32GB Minimum |
Hard Disk | SATA/SSD/SAS See SQL Server system setup document for more details. |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows Server 2012, 2012 R2, 2016, or 2019 64 Bit |
USB | USB 3.0 / USC-C |
Patriot Server Computer – 100,000+ Clients
Processor | Intel Xeon or AMD Equivalent. Multi Core 4 core minimum. |
RAM | 64GB Minimum |
Hard Disk | SATA/SSD/SAS See SQL Server system setup document for more details. 500gb+ |
Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |
Video Adapter | Minimum Screen Resolution 1600 x 900. 16x9 Display |
Operating System | Windows Server 2012, 2012 R2, 2016, or 2019 64 Bit |
USB | USB 3.0 / USC-C |
Typical Hardware Specifications for SQL standalone servers
SQL Server Stand Alone – Up to 100,000 Clients
Processor | One or more Intel Xeon or AMD Equivalent. Multi Core. |
RAM | 32GB Minimum |
Hard Disk | SATA/SSD/SAS See SQL Server system setup document for more details. |
Network Adapter | Fast Ethernet 1 - 10GB (Seperate 10Gigabit recommend for iSCSI) |
Video Adapter | Minimum Screen Resolution 1680 x 1050. 16x9 Display |
Operating System | Windows Server 2012, 2012 R2, 2016, or 2019 64 Bit |
USB | USB 3.0 / USC-C |
USB | SAN storage with seperate iSCSI 10GB network |
SQL Server Stand Alone – Over 100,000 Clients
Processor | One or more Intel Xeon or AMD Equivalent. Multi Core. |
RAM | 128GB Minimum |
Hard Disk | SATA/SSD/SAS See SQL Server system setup document for more details. |
Network Adapter | Fast Ethernet 1 - 10GB (Seperate 10Gigabit recommend for iSCSI) Fibre channel network adapter |
Video Adapter | Minimum Screen Resolution 1680 x 1050. 16x9 Display |
Operating System | Windows Server 2012, 2012 R2, 2016, or 2019 64 Bit |
USB | USB 3.0 / USC-C |
USB | SAN storage with fibre channel (FC) |