The following guidelines provide an estimation of the hardware resources required to deploy SQL Compliance Manager 8.0, depending on the number of servers you want to monitor with SQL Compliance Manager.
Matrix based on 6000 - 8000 events per second per 25 instances.
Operating System - Windows 2016 or later (64-bit).
| VM | Number of Collection Servers | Monitored Instances per Collection Server | CPU Cores | RAM | Storage Capacity (GB) |
|---|---|---|---|---|---|
| 100+ Instances | |||||
| Collection Mgmt Services Server | 5 | 20 | 8 | >= 48 GB | 150 GB |
| Repository Server | - | - | 16 - 24 (1 core per 6 - 8 instances) | 16 GB | 2500 - 3000 |
| 51 - 100 Instances | |||||
| Collection Mgmt Services Server | 2 - 4 | 25 | 8 | 24 - 48 GB | 150 GB |
| Repository Server | - | - | 16 | 16 GB | 2000 |
| 21 - 50 Instances | |||||
| Collection Mgmt Services Server | 1 - 2 | 20 - 25 | 6 | 16 - 24 GB | 150 GB |
| Repository Server | - | - | 8 | 16 GB | 1000 |
| 0 - 20 Instances | |||||
| Collection Mgmt Services Server | 1 | 20 | 6 | 8 - 16 GB | 150 GB |
| Repository Server | - | - | 4 | 8 GB | 400 |
IDERA SQL Compliance Manager is fully supported on Virtual Machines, both HyperV and VMware.