System Requirements
Read this section to learn more about system requirements for Cygna Auditor and its database server. Depending on your company size and the average number of changes recorded per day, the requirements can vary significantly. Use the metrics below as a general guideline and consider scaling your Cygna Auditor infrastructure if needed:
Distributed Deployment—Medium and Enterprise Environments
Single Server Deployment—Small Businesses and PoC
Distributed Deployment—Medium and Enterprise Environments
Cygna Labs recommends distributed configuration with two servers for medium and enterprise environments.
Cygna Auditor Application Server
Ensure the computer where you install Cygna Auditor (application server) meets the following hardware and software requirements and has all necessary software components and roles enabled.
|
COMPONENT |
REQUIREMENTS |
|---|---|
|
Hardware |
|
|
Operating system |
|
|
Server roles and features |
Note: Depending on the OS, you might need to install ASP.NET manually. |
|
Additional software |
Any modern browser, preferably Google Chrome or Microsoft Edge. |
Database Server
Review the system requirements for the database server.
|
COMPONENT |
REQUIREMENTS |
|---|---|
|
Hardware |
For better performance, adjust your hardware configuration based on the number of changes Cygna Auditor collects daily. The more change records are collected and stored in the database, the greater the impact on your database server. The disk space required for the audit data can grow significantly over time. |
|
Operating system |
Any modern OS provided it supports installation of Microsoft SQL Server |
|
Database |
Standard and Enterprise editions are supported. Note that SQL Express edition is not supported. |
|
Enabled features |
Full-text search |
Single Server Deployment—Small Businesses and PoC
For smaller businesses and PoC deployments, you can opt for a single server deployment. In this case, the Cygna Auditor application and database servers will reside on the same server.
|
COMPONENT |
REQUIREMENTS |
|---|---|
|
Hardware |
For better performance, adjust your hardware configuration based on the daily changes Cygna Auditor collects. The more change records are collected and stored in the database, the greater the impact on your database server. The disk space required for the audit data can grow significantly over time. |
|
Operating system |
|
|
Server roles and features |
Note: Depending on the OS, you might need to install ASP.NET manually. |
|
Database |
Standard and Enterprise editions are supported. Note that SQL Express edition is not supported. Enable full-text search for the database instance. |
|
Additional software |
Any modern browser, preferably Google Chrome or Microsoft Edge. |
Note: For more information about Cygna Auditing & Security Suite (former PowerBroker Management Suite), including system requirements, installation procedures, and configuration steps, please refer to
Recommended Database Maintenance
Cygna Labs recommends a weekly SQL Server maintenance job that includes the following elements. These items may be added using the SQL Server Maintenance Plan Wizard. See the Microsoft SQL Server documentation for details.
- Shrink Database
- Allow 10% free space after shrink
- Return freed space to the operating system
- Rebuild Index
- Rebuild indexes if fragmentation exceeds 20% and the page count exceeds 500 pages
- Update Statistics
- All existing statistics
- Full scan
- Backup Database
Cygna Labs recommends using the archive and purge features only to retain the data required for compliance at your organization. If these features are not enabled at install time, the first few operations will be completed successfully but will have a higher SQL load than usual. The jobs should not be scheduled to run simultaneously as your SQL Maintenance Plan.
Cygna Auditor supports an optional database maintenance task. See Scheduler job configuration for details on configuring this task for your database.
