Vertica performance degradation after Hyper-V upgrade

kfhpe

Hello,
we upgraded the MS Windows server 2008 R2 Hyper-V cluster to MS Windows server 2012 R2 Hyper-V cluster. After the upgrade we found that Linux guest with Vertica is having performance problems – the performance degradation is from 30% to 45%. The Linux guest is running the Vertica database. Before the upgrade, there were no problems with Linux guest.

What have we did + the result:
1. Turn off the numa in grub.conf (numa=off) -> performance degradation was the same,
2. Update LIS to version 4.2.5 -> performance degradation was the same,
3. Increase the number of cores from 4 to 16 -> performance degradation was the same,
4. We also changed the I/O scheduler to "deadline" and we achieved better performance,
but it was not the same performance as before the upgrade.

Information about the Linux guest:
OS: Red Hat 6.9
RAM: 64GB
Number of vCPU: 4
Application: HPE Vertica 7.2.3

Thank you.

Jim_Knicely

Take a look at this doc to verify that you meet the requirements and made the correct changes to your VMs:

https://my.vertica.com/kb/Configuring-and-Monitoring-Virtual-Machines-for-HP-Vertica-7-2-x/Content/BestPractices/Configuring-and-Monitoring-Virtual-Machines-for-HP-Vertica-7-2-x.htm