Query to Database Failing - Large Number of VMs

[ryanparsonsekco]

I have a large environment of over 400 virtual machines on 1 vCenter, with these VMs having fairly long names (20+ characters).

This issue only occurs on the Overview dashboard when all VMs in the top bar is selected. Selecting multiple VMs manually (up to around 100) will work fine, but as soon as you go over a certain number, it fails to query. I suspect this is a limit on how long the query can be, with all VMs being selected it would have to include all the VM names in the query, and with over 400 long VM names I could see that being the issue.

This mainly affects the VM-related monitoring graphs at the bottom of the overview, but can also cause other graphs, such as the main overview at the top of the dashboard to fail at random times.

Thank you for the great dashboard templates, hopefully, this can be resolved someway.

[jorgedlcruz]

Hello,
Thank you so much for the comment. I am wondering what is the limit on the vSphere Client, I am not sure you can select either 400 VMs on the Real-time view, can you?

Might check on Grafana if there is a way to paginate that, probably with some plugin.