DDC Collector Database
DDC Collector uses Microsoft SQL Server database as data storage. You need to create dedicated DDC Collector database on your SQL Server instance and configure it as shown below for the product to function properly. You can create the database manually—Using SQL Server Management Studio or Transact-SQL. Refer to the following Microsoft article for detailed instructions on how to create a new database: Create a Database.
NOTE: For performance purposes Netwrix strongly recommends to separate DDC Collector and SQL Server machine.
Before you create a DDC Collector database, consider the following:
- The database can be hosted on the SQL Server 2008 R2 Standard Edition (or later).
Depending on the number of objects in the database, it can take from 5 to 50 GB of disk space.
To configure the DDC_Collector_Database database
- On the computer where SQL Server instance with the DDC Collector database resides, navigate to Start → All Programs → Microsoft SQL Server → SQL Server Management Studio.
- Connect to the server.
- Locate the DDC Collector database, right-click it and select Properties.
Select the Files page and set the Initial Size (MB) parameter for PRIMARY file group to 512 MB.
Click next to PRIMARY file group and set Autogrowth / Maxsize as follows:
- Minimal—128 MB.
- Large audited environment— 512 MB.
Maximum File Size
Go to Options page and make sure that the Recovery model parameter is set to "Simple".