Databases Solution
The core components for Netwrix Access Analyzer (formerly Enterprise Auditor) are the Access Analyzer Console server, SQL Server, and Access Information Center. See the Requirements topic for the core requirements.
In addition to these, Access Analyzer requires integration with Netwrix Activity Monitor to scan event activity data. See the Netwrix Activity Monitor Documentation for installation requirements and information on collecting activity data.
See the following topics for target environment requirements:
- Target Db2 Requirements, Permissions, and Ports
- Target MongoDB Requirements, Permissions, and Ports
- Target MySQL Requirements, Permissions, and Ports
- Target Oracle Requirements, Permissions, and Ports
- Target PostgreSQL Requirements, Permissions, and Ports
- Target Redshift Requirements, Permissions, and Ports
- Target Microsoft SQL Server Requirements, Permissions, and Ports
- Target Azure SQL Requirements, Permissions, and Ports
Databases Solution Requirements on the Access Analyzer Console
RAM, CPU, and Disk Space
These are dependent upon the size of the target environment:
| Environment | Extra-Large | Large | Medium | Small |
|---|---|---|---|---|
| Definition | > 1 TB database size | Up to 1 TB database size | ~250 GB database size | ~50 GB database size |
| RAM | 24 GB | 16 GB | 12 GB | 4 GB |
| Cores | 8 CPU | 8 CPU | 4 CPU | 2 CPU |
| Disk Space | 460 GB | 280 GB | 160 GB | 80 GB |
If running Sensitive Data Discovery (SDD) scans, you must increase the minimum amount of RAM. Each thread requires a minimum of 2 additional GB of RAM per host. For example, a job configured to scan 8 hosts at a time requires an extra 16 GB of RAM (8x2=16).
Additional Server Considerations for Oracle Scans
For scanning Oracle databases, the following are additional requirements for the Console server:
- Windows Management Framework 3+ installed
- PowerShell 3.0+ installed
- NMAP installed
- For Instance Discovery, NMAP installed
Additional Server Considerations for SQL Server Scans
For scanning SQL databases, the following are additional requirements for the Console server:
- Windows Management Framework 3+ installed
- PowerShell 3.0+ installed
Sensitive Data Discovery Auditing Requirement
Access Analyzer installs the appropriate JDK (Java) version for Sensitive Data Discovery on the server. The JDK deployed is prepackaged and doesn't require any configuration; it has been preconfigured to work with Access Analyzer and should never be customized through Java. It will not conflict with other JDKs or Java Runtimes in the same environment.
Databases Solution Requirements on the SQL Server
RAM, CPU, and Disk Space
These are dependent upon the size of the target environment.
| Environment | Extra-Large | Large | Medium | Small |
|---|---|---|---|---|
| Definition | > 1 TB database size | Up to 1 TB database size | ~250 GB database size | ~50 GB database size |
| RAM | 64 GB | 32 GB | 16 GB | 8 GB |
| Cores | 16 CPU | 12 CPU | 8 CPU | 4 CPU |
| Number of Disks | 4 | 4 | 4 | 4 |
| Operating System Disk | 160 GB | 160 GB | 160 GB | 160 GB |
| SQL Database Disk | 500 GB | 320 GB | 240 GB | 100 GB |
| SQL Transaction Log Disk | 120 GB | 100 GB | 80 GB | 40 GB |
| SQL TEMP DB Disk | 320 GB | 240 GB | 160 GB | 80 GB |