Tech Specs: Database Compliance Auditing for SQL Server

SQL Compliance Manager - Technical Specifications

What Is New

Expand

Version 5.8

  • Data manipulation language (DML) and select activities captured via Extended Events by default
  • Page compressed indexes in repository Events table
  • Compressed or uncompressed trace files for transfer from agents to collection server

Version 5.7.1

  • There are no new features in this product version release.

Please refer also to the product documentation New features and fixed issues.

Version 5.7.0

  • Supports SQL Server 2019
  • Supports Windows Server 2019
  • New reports
  • Limit report access to specific users
  • Report filter improvements

Please refer also to the product documentation Previous features and fixed issues.


Platform Support

Expand
  • Web console: IDERA Dashboard
  • Collection server: Microsoft Windows
  • Repository: Microsoft SQL Server
  • Agents: Microsoft Windows
  • Audited database instances: Microsoft SQL Server
  • Cloud: Microsoft Azure VM, Amazon EC2

Please refer also to the product documentation Software requirements.


System Requirements

Expand

Web Console

Collection Services

  • CPU clock rate: 2 GHz +
  • Random-access memory (RAM): 8 GB +
  • Storage drive space: 20 GB + for trace directory
  • Microsoft Windows: Server 2019, Server 2016, 10, 8.1, 8, Server 2012, Server 2008 R2, 7, Server 2008 SP1 SP1+; 64-bit, 32-bit

Repository

  • Storage drive space: 60 GB to 90 GB
  • Microsoft SQL Server: 2019 (Windows), 2017 (Windows), 2016, 2014, 2012 SP1, 2008 R2 SP1+, 2008 SP1+; Standard, Enterprise edition

Agents

  • Microsoft Windows: Server 2019, Server 2016, 10, 8.1, 8, Server 2012, Server 2008 R2, 7, Server 2008 SP1 SP1+; 64-bit, 32-bit

Audited Database Instances

  • CPU clock rate: 1 GHz +
  • Random-access memory (RAM): 512 MB +
  • Storage drive space: 2 GB +
  • Microsoft SQL Server: 2019 (Windows), 2017 (Windows), 2016, 2014, 2012 SP1, 2008 R2, 2008; Express, Standard, Enterprise edition
    • Microsoft Windows: Server 2019, Server 2016, Server 2012 R2, Server 2012, Server 2008

SQL Compliance Manager does not install any components, databases, dynamic link libraries (DLLs), scripts, stored procedures, or tables on the managed instances.

Cloud

  • Runs on cloud virtual machines such as Microsoft Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2) with Microsoft Windows.
  • Audits database instances on cloud virtual machines such as Microsoft Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).

Please refer also to the product documentation Hardware requirements and Software requirements.


Version History

Expand

Version 5.6.1

  • Sensitive column search

Version 5.6.0

  • Capture logout events
  • Default audit configuration settings
  • Add databases automatically
  • Configurations clarifications
  • Server level trusted users
  • Sensitive columns auditing
  • Web console updates
  • Log file
  • Non-sysadmin
  • Increase the number of threads processed
  • GDPR regulation
  • Configuration check report
  • Regulation compliance check report

Version 5.5.1

There are no new features in this product version release.

Version 5.5.0

  • Includes updated and new regulation guidelines
  • Auditing available via SQL Server audit logs
  • Includes a row count feature
  • Enable SQL Server extended events auditing from the Windows management console
  • Supports SQL Server 2017
  • Supports Windows Server 2016
  • Allows users to create sensitive column data sets
  • BAD alerts
  • Agent deployment method
  • Allows users to install or upgrade on a non default drive

Version 5.4.2

  • Supports TLS 1.2

Version 5.4.0

  • Improves archiving through the availability of SQL Server extended events
  • Includes new sensitive column search
  • Offers Windows console functionality in the web console
  • Includes updated regulatory guideline templates

Version 5.3.1

  • Supports SQL Server 2016

Version 5.3.0

  • Expanded the web console to provide a richer set of capabilities online
  • Integration with IDERA Dashboard 2.2
  • Limited Support for SQL Server 2016

Version 5.0.0

  • Fully supports the SQL Server Always On Availability Groups feature 
  • Offers a technology preview of a new web-based dashboard
  • Moved to the Windows .NET 4.0 framework

Please refer also to the product documentation Previous features and fixed issues.

Try SQL Compliance Manager FREE for 14 days
SQL-Compliance-Manager-Audit-SQL-Database-Screenshot

Monitor, audit and alert on SQL Server changes

  • Audit sensitive data to see who did what, when, where, and how
  • Monitor and alert on suspicious activity to detect and track problems
  • Satisfy audits for multiple industry regulatory requirements
  • Select from over 25 pre-defined compliance reports and create custom views
  • Lightweight data collection agent minimizes server impact
Start for Free


Share This
Contact IDERA:
+1 (713) 523-4433