Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to find VMWare ESX Host event messages using VPXV_EVENTS

21 January,2016 by Tom Collins

Question: I’m trying to collate some VM  error alerts for a server outage. As well as OS and SQL Server logs I need to find any event logging for ESX hosts. I’m looking to execute a query on the VCDB database with some date range parameters and a ESX host parameter.

Answer: In VMWare 5.5 it is possible to query the VCDB database Views. There is a wealth of information in these SQL Views. As well as host information such as configurations and other met , there is detailed logging for historical statistics and event logging

Find the Virtual Centre SQL Server Instance supporting your environment and check your login account has read privileges.

If the underlying tables have not been archived the resultset from these views can be large . The improve the response use some filter predicates.

Find the ESX host name by using Query VMWare vCenter VCDB database for guest and host details ...

Once you've found the ESX host decide on the date range.


select EVENT_ID,
 WHERE host_name = ''
 and CREATE_TIME between '2016-01-20 18:00:00.000' and '2016-01-21 14:00:00.000'


Some interesting event messages  to consider are:


In a future post , I’ll outline some approaches to troubleshooting these alerts

 Read More

SDD_Service error and vmware multipath - SQL Server DBA

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to find VMWare ESX Host event messages using VPXV_EVENTS | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer