Go Up
You are here: Netwrix Auditor DDC EditionDDC CollectorPre-istallation ChecklistDistributed Query Server Mode

Distributed Query Server Mode

The Distributed Query Server (DQS) mode allows re-balancing load while collection, indexing and classification. The load is distributed evenly over all enabled DDC Collector instances that allows processing up to 32 m objects per cluster of 4 servers. General procedure is as follows:

  • Install the first DDC Collector instance where you are going to enable DQS mode.
  • Install other DDC Collector instances.
  • Enable DQS mode on the first instance.
  • Add servers to the Distributed Query Servers list.
  • Re-collect data sources.

Refer to To enable DQS Mode for detailed instructions on how to re-balance load to your system.

To enable DQS Mode

Recommendations below refer to clear install of DDC Collector in extra-large environment. If you upgraded from the previous version, perform steps 6 - 18.

  1. Prepare machines for SQL Server instances where DDC Collector database and Netwrix Auditor (including Categories) databases reside. Consider the following recommendations:

    • Each SQL Server instance must be deployed to a separate physical disk.
    • For better performance, deploy both SQL Server instances to dedicated SSD storages. The configuration where one of the SQL Server instances runs on HDD is acceptable, but not recommended. Using HDD for all instances lead to performance loss and long report generation.
  2. Create and configure DDC Collector database as described in the DDC Collector Database section.
  3. Prepare server to install DDC Collector. Meet the XLarge environment (up to 32 m objects) hardware requirements and general Software Requirements.
  4. Install and configure DDC Collector as described in the Install DDC Collector section.

  5. Add license.
  6. Prepare servers to install other DDC Collector instances assuming one server per one instance. Each server must meet the XLarge environment (up to 32 m objects) hardware requirements and general Software Requirements.
  7. Copy the Netwrix_Auditor_DDC_Collector.exe file to the server considered to be the next DDC Collector instance.
  8. Run installation package.
  9. Proceed with installation as described in the Install DDC Collector section until SQL Database configuration.
  10. On the SQL Database step, provide the name of the SQL Server instance that hosts DDC Collector database you configured on the step 2.

    NOTE: Ignore the confirmation dialog on the existing schema in the selected SQL database.

  11. Complete the installation.
  12. Repeat the steps 7 - 11 for each successive DDC Collector instance.
  13. Add license.
  14. On the computer where the first DDC Collector instance installed, open DDC Collector console.

  15. Navigate to Config Utilities DQS.

  16. Select Enable DQS.

    NOTE: Once DQS mode enabled you cannot roll back your configuration. Netwrix strongly recommends to ensure that you took a full backup of your environment.

  17. On the DQS tab, click Add to add servers you prepared on the step 6 one by one.

    Complete the following fields:

    Option Description

    Server

    Provide server name.

    NOTE: FQDN format is not supported, use the NetBIOS name.

    QS Path

    Substituted automatically after adding server name.

    Active

    Select to enable the instance.

    Alternate Server

    Netwrix recommends using default values.

    Alternate QS Path

    Netwrix recommends using default values.

  18. Review the list of DQS servers. For example:

  19. When prompted, re-collect data sources to re-distribute the content across all of the configured servers.
  20. You can review system health and services dashboards to check your configuration. See Review Dashboard for more information.

Go Up