Performance on Hypervisor Products
Pervasive PSQL Vx Server is the database product intended for use with hypervisor products and an environment of virtual machines (VMs). To achieve the best performance for Pervasive PSQL Vx Server, ensure the following:
•
Adherence to the performance best practices recommendations from the hypervisor vendor.
•
The VM hosting Pervasive PSQL Vx Server has ample memory (RAM).
•
The hypervisor host has enough virtual CPUs to minimize virtual CPU contention among all of the VMs on the same machine. This prevents contention with the VM running Pervasive PSQL Vx Server. If you use affinity rules, ensure that all cores are running on the same socket.
•
The Pervasive PSQL Vx Server data files reside on very fast physical storage and minimize spindle contention and controller contention for the physical storage device.