The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica performance degradation after Hyper-V upgrade

edited July 2018 in General Discussion

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
Number of vCPU: 4
Application: HPE Vertica 7.2.3

Thank you.


Leave a Comment

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