We just had a very good and interesting VMTN Podcast on virtualized MS SQL performance and best practices. One of the questions was about disk performance. Hemant Gaidhan talked about esxtop and how to discover possible performance issues, and specifically mentioned latency. I’ve never really looked into this section of esxtop and did a quick search and of course the “Interpreting esxtop Statistics” answered which counters to watch and what each counter represents:
Section 4.2.2 Latency Statistics
This group of counters report latency values measured at three different points in the ESX storage stack. In the context of the figure below, the latency counters in esxtop report the Guest, ESX Kernel and Device latencies. These are under the labels GAVG, KAVG and DAVG, respectively. Note that GAVG is the sum of DAVG and KAVG counters.
I recommend reading the rest of the 4.2.2 section to anyone looking for more indepth info on esxtop and storage performance. Also read page 14/15 of Hemant’s document on SQL Server performance/best practices. Another great read and tip from Hemant was the “Scalable Storage Performance” whitepaper.