The following guidelines provide an estimation of the hardware resources required to deploy SQL Compliance Manager depending on the number of servers you want to monitor with SQL Compliance Manager.
Deployments under 20 Servers
Less than 20 SQL Servers being audited and 10,000 events per hour.
SQL Compliance Manager Repository and Collection Service reside on:
Type | Requirement |
|---|---|
| Operating System | Windows Server 2016 or above (64-bit) |
| Memory | 8 - 16 GB |
| CPU | 8 cores per 25 instances |
| SQLcm Repository Size | 400 GB |
These hardware and configuration requirements are basic requirements and can be interpreted differently depending on each environment´s audit requirements and event activity scenarios.
The expected repository growth is approximately 1 GB per every 1 million transactions.
10K events per hour will require 7 GB of space per month.
Deployments of 20-50 Servers
20-50 SQL Servers being audited and 20,000 events per hour.
SQL Compliance Manager Repository and Collection Service reside on:
Type | Requirement |
|---|---|
| Operating System | Windows Server 2016 or above (64-bit) |
| Memory | 16 - 24 GB |
| CPU | 8 cores per 25 instances |
| SQLcm Repository Size | 1000 GB or more |
These hardware and configuration requirements are basic requirements and can be interpreted differently depending on each environment´s audit requirements and event activity scenarios.
The expected repository growth is approximately 1 GB per every 1 million transactions.
20K events per hour will require at least 15 GB of space per month.
Deployments of 50-100 Servers
50-100 SQL Servers being audited and 20,000 events per hour.
SQL Compliance Manager Repository and Collection Service reside on:
Type | Requirement |
|---|---|
| Operating System | Windows Server 2016 or above (64-bit) |
| Memory | 24 - 48 GB |
| CPU | 8 cores per 25 instances |
| SQLcm Repository Size | 2000 GB or more |
These hardware and configuration requirements are basic requirements and can be interpreted differently depending on each environment´s audit requirements and event activity scenarios.
The expected repository growth is approximately 1 GB per every 1 million transactions.
20K events per hour will require at least 15 GB of space per month.
Deployments of 100 Servers or more
200 SQL Servers being audited and 30,000 events per hour.
SQL Compliance Manager Repository and Collection Service reside on:
Type | Requirement |
|---|---|
| Operating System | Windows Server 2016 or above (64-bit) |
| Memory | >= 48 GB |
| CPU | 8 cores per 25 instances |
| SQLcm Repository Size | 2.5-3 TB (based on an average of 20GB/instance) |
These hardware and configuration requirements are basic requirements and can be interpreted differently depending on each environment´s audit requirements and event activity scenarios.
The expected repository growth is approximately 1 GB per every 1 million transactions.
30K events per hour will require at least 300 GB of space per month.
IDERA SQL Compliance Manager is fully supported on Virtual Machines, both HyperV and VMware.