SQL execution took too long

This dashboard is aimed at keeping track of SQL response time from a vCenter point of view. A healthy database backend is a must for vCenter Server, as a lot of thing is done in db.

SQL execution times are extended and take a long time to complete.

If you have performance issue with your db server, there will be a lot of nasty outcome in your vCenter, such as failure of stats collection, gaps in performance charts, tasks queuing up, …

dashboard-sqltoolong1 dashboard-sqltoolong2

If there is some issue on vcd side, you will see on vpxd.log files some statement about it:

2015-03-06T10:50:06.207+01:00 [05384 warning 'Default' opID=SWI-7c33d20] [VdbStatement] Execution elapsed time: 6189 ms

The SQLTooLong dashboard will display database latency based on the vdb_latency field for every configured vCenter you have.

The golden rule for this dashboard is the lower, the better! If you have some unexpected high values (depending on your environment) ⇒ go check on your DBA team 🙂

 

dashboard-sqltoolong

 

This dashboard is actually a template and needs a bit of configuration. You need to replace the vCenter names by yours. Don’t hesitate to add some query fields to split them up if you have a lot of vCenter.

2015-03-06_14-55-49

Associated VMware KB articles:

 

This is a vCenter dashboard, you need to configure vpxd.log shipping first
 This dashboard is embedded in SexiLog. If you want up-to-date version for your own platform, the Gist code for this dashboard is:  https://gist.github.com/sexibytes/522cff646e64ea8dd16a 
More information about dashboard import in Kibana is available here