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 SQLCM.

Installs 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 SystemWindows Server 2003 or above
Memory6-12 GB
CPU

Intel® Xeon® E3-1240 v5 3.5GHz 8M cache (4 Core)

SQLcm Repository Size

40-60 GB (Pre-allocate this space)

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 1GB per every 1 million transactions.

Installs 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 SystemWindows Server 2003 or above (64 bit)
Memory12-24 GB
CPU

Dual Intel® Xeon® E3-1240 v5 3.5 GHz 8M cache (4 Core)

SQLcm Repository Size250 GB or more (Pre-allocate this space)

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 1GB per every 1 million transactions

Installs 200 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 SystemWindows Server 2003 or above (64 bit)
Memory24-48 GB or more
CPU

4-6 Dual Intel® Xeon® E3-1240 v5 3.5 GHz 8M cache (4 Core)

SQLcm Repository Size1TB or more (Pre-allocate this space)

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 1GB per every 1 million transactions

The SQL Compliance Manager Collection Service should not reside on a virtual machine.



SQL Compliance Manager audits all activity on your server. Learn more > >

IDERA Website | Products Buy Support Community About Us | Resources Legal

  • No labels