Vertica performance degradation after Hyper-V upgrade

kfhpekfhpe Registered User
edited July 23 in Vertica Forum

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.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file