SQL Server
Patriot uses Microsoft SQL. This provides for a scaleable database with consistent performance irrespective of database size. SQL 2014+ is supported.
Smaller monitoring stations can use MS SQL 2014+ Express. There are limits on performance and database size but they will deliver good results with Patriot 6 where signal volume is not expected to be high. SQL Express is upgradeable to fully licensed SQL packages when required.
Larger server based Patriot systems will require MS SQL Standard version (Enterprise SQL is generally not required). There are two options for SQL Server licensing of Standard version. Per user/device CAL licensing and Per Core based licensing.
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 for monitoring centres that have over 25,0000 accounts
Patriot Workstation Client computers
| Operating System | Windows 10 or 11 |
| Processor | Multi Core 64x recommended |
| RAM | 8GB Minimum |
| Hard Disk | SATA/SSD 80GB or greater |
| Network Connectivity | Fast Ethernet 100 MBPS (Gigabit recommended) |
| Display | Patriot Lite/Professional 1280x 800 min
Patriot Enterprise 1440x900 min (Higher resolution for Enterprise only required if the right panel is used).
Please note that these resolutions assume a standard DPI setting. If you are using a custom DPI setting or magnifying the screen text and items, then you will need to use a higher resolution.
For example using a 125% magnifier setting, requires a screen resolution of 1600x1200 for Professional, and 1920x1080 for Enterprise.
Monitoring centres that will be monitoring camera systems should have dedicated graphics cards for each workstation. |
Patriot Server computers - Minimum
| Operating System | Windows Server 2016+ supported |
| Processor | 64-bit multi-core processor |
| RAM | Minimum 16 GB. As a rough guide an additional 1GB per 1000 Patriot sites monitored is recommended. |
| Hard Disk | Minimum 80 GB SAS/SCSI in RAID 1 configuration (Not SATA) |
| Network Connectivity | Fast Ethernet Gigabit+ |
| Serial Connections | 1 per serial receiver (if any). |
| USB Ports | Printer, possibly GSM Modem as required. |
Less than 2000 alarm client records
| Operating System | Windows 10 Professional 64 Bit (Windows Server 2016+ supported) |
| Processor | 64-bit multi-core processor |
| RAM | Minimum 16 GB. |
2,000 to 10,000 alarm client records
| Operating System | Windows Server 2016+ supported |
| Processor | 64-bit multi-core processor |
| RAM | Minimum 16 GB. As a rough guide an additional 1GB per 1000 Patriot sites monitored is recommended. |
| Hard Disk | Disk drive 250GB minimum (depends on amount of archived history required)) |
10,000 to 50,000 alarm client records
| Operating System | Windows Server 2016+ supported |
| Processor | CPUs with 4 to 8 cores |
| RAM | Minimum 32 GB. |
| Hard Disk | Disk drive 500GB minimum (depends on amount of archived history required) |
50,000 to 100,000 alarm client records
| Operating System | Windows Server 2016+ supported |
| Processor | Separate Patriot and SQL servers. Server CPUs with 4 to 8 cores. Patriot Server 4 to 8 Cores. |
| RAM | SQL Server Minimum 64GB of RAM. Patriot Server Minimum of 32GB of RAM. |
| Hard Disk | SQL Server Disk drive 500GB minimum (depends on amount of archived history required). Patriot Server Disk Drive 128GB minimum |
100,000+ alarm client records
| Operating System | Windows Server 2016+ supported |
| Processor | Separate Patriot and SQL servers. Server CPUs with 8+ cores. Patriot Server 16+ Cores. |
| RAM | SQL Server Minimum 128GB of RAM. Patriot Server Minimum of 64GB of RAM. |
| Hard Disk | SQL Server Disk drive 500GB minimum (depends on amount of archived history required). Patriot Server Disk Drive 128GB minimum. |
| Network Adapter | Fast Ethernet 100 MBPS (Gigabit recommended) |