The following sections provide the hardware requirements for each IDERA SQL Compliance Manager component. For more information, see Product components and architecture.
Audited SQL Server
The audited SQL Server computer is the computer that hosts the SQL Server databases you want to audit. In a clustered environment with virtual SQL Servers, the audited SQL Server is the virtual SQL Server. However, each node (physical computer) in the cluster that hosts the virtual SQL Server must meet or exceed these requirements.
To achieve optimal performance, ensure each SQL Server computer meets or exceeds the following hardware requirements.
| Hardware Type | Requirement |
|---|---|
| CPU | 1 GHz |
| Memory | 512 MB |
| Hard Disk Space | 2 GB |
Collection Server
The Collection Server computer is the computer that hosts the Collection Service and processes trace files. This computer also hosts the Repository databases.
To achieve optimal auditing performance and data storage, ensure the Collection Server computer meets or exceeds the following hardware requirements.
| Hardware Type | Requirement |
|---|---|
| CPU | 2 GHz |
| Memory | 8 GB |
| Hard Disk Space | 20 GB for trace directory 60-90 GB for Repository |
For more information, see SQL Compliance Manager Hardware Sizing guidelines.
Management Console
The Console computer is the computer that hosts the SQL Compliance Manager Management Console. You can install the console on the Collection Server computer, or any client computer for remote access to your audit data.
Ensure each console computer meets or exceeds the following hardware requirements.
| Hardware Type | Requirement |
|---|---|
| CPU | 1 GHz |
| Memory | 512 MB |
| Hard Disk Space | 150 MB |