Skip to content
  • There are no suggestions because the search field is empty.

How to Install SQL Server 2022 for Webgility Desktop Without PolyBase to Prevent Large Dump Log Files

This article helps Webgility Desktop users installing SQL Server 2022 for Webgility Desktop without PolyBase which can cause extremely large dump log files and can consume a lot excessive disk space. The issue often arises because the PolyBase Query Service feature is enabled by default but is unnecessary for Webgility Desktop. The guide provides step-by-step instructions to disable this feature, ensuring a clean and optimized SQL Server installation.

Causes of Issue

  • PolyBase Enabled by Default: During SQL Server 2022 setup, PolyBase can generate massive dump logs.

  • Unnecessary Component: Most Webgility Desktop users do not require PolyBase, which is used primarily for querying external data sources like Hadoop or Azure Blob Storage.

  • Disk Space Consumption: These logs may grow over 300 GB, reducing performance and filling up your system drive.

Step-by-Step Instructions

1. Launch SQL Server 2022 Installer

  • Download and run the official SQL Server 2022 installation setup.

  • Choose New SQL Server stand-alone installation or add features.

2. Navigate to Feature Selection

  • Once the installation wizard loads, proceed to the Feature Selection screen.

3. Disable PolyBase Feature

  • Locate PolyBase Query Service for External Data.

  • Uncheck this option to exclude it from installation.

✅ This feature is not needed for Webgility Desktop and disabling it helps avoid large dump logs.

4. Complete Installation

  • Continue through the remaining installation steps as guided.

  • Finalize and complete the installation.

Post-Installation Best Practices

  • Only install PolyBase if your workflow specifically requires querying external data sources.

  • Regularly monitor the SQL Server log folder for abnormal growth:

    • Default path: C:\Program Files\Microsoft SQL Server\MSSQL15.<InstanceName>\MSSQL\Log

  • Delete or archive older dump logs if space becomes an issue.

Optional Additional Steps

If you've already installed SQL Server 2022 and enabled PolyBase by mistake:

  1. Uninstall SQL Server Instance from Control Panel > Programs and Features.

  2. Reinstall SQL Server using the above guide, excluding PolyBase.

  3. Confirm no large dump logs are being created in the log directory.

Note

Webgility Desktop does not require PolyBase for operation. Excluding it during setup is safe and recommended to avoid unnecessary log generation and disk usage.