In order to restrict the memory usage of the queries in Virtual DataPort server I would configure the memory usage and swapping policy in the Virtual DataPort Administration Tool. I would perform the following steps in the Virtual DataPort Administration Tool to configure the Memory usage:
* I would click on the **Administartion -> Server configuration** menu and select the **Memory usage tab**.
* In the memory usage section I would configure the** maximum query size** and the **swapping parameters** as required.
You could take a look at the [Configuring the Memory Usage and Swapping Policy
](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#memory-usage-settings ) section of the Virtual DataPort Administration Guide for more details.
You can also take a look at the [Memory Management](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/memory_management/memory_management) section of the Virtual DataPort Administration Guide for more information.
Hope this helps!