ESX Performance Monitoring

I have a SQL job that can run in mid-day and perform in a short period (1 hour).  I have the same job run during peak hours and get 2.3 hours until completion.  I have viewed storage and see no bottleneck.  Is there a type of monitoring that I can use to monitor ESX performance during this job so that I can see where I'm maxing out at?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SteveIT ManagerCommented:

Try for free monitoring tools for virtual servers as well as other useful tools
vmwarun - ArunCommented:
Are you using vCenter or Virtual Center to manage your ESX/ESXi Hosts ?
I might suggest starting inside the sql virtual machine with the normal tools (taskmgr and perfmon) to see if the vm is starved for cpu, disk, or network.  Once you identify that, then look at the tools above to identify which vm's are contending for that particular resource during your bottleneck.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

use the performance tab in vcenter. from there you can view realtime (20secs), a day, week, month, etc.  You want to monitor the big four,  CPU, memory, disk , and network,

Example check
CPU ready should be 0-5%
over 10% performance issue

memory: check balooning

securitythreatAuthor Commented:
All of the above have been done.  The only tool that will help verify is from the ESX side and not the guest.  I have done the guest and see the issue.  However, know I have to determine what the root cause is.

You could try to run esxtop on the ESX server during peak and offpeak time and check the counters.

The following link might help in understanding the parameters

Check the %WAIT for vmkernel resources as well as the disk throughput stats and queue stats.
securitythreatAuthor Commented:
Sunshine, you are right on it.  However, I need to chart that data for presentation like purposes to present to team for performance review.
vmwarun - ArunCommented:
Try to use ManageEngine OpManager tool, setup the counters at both ESX and VM level since OpManager has got both Server Performance and Application Performance monitoring capabilities to monitor for a week.
Once monitoring has been done, you can use the charts to check the root cause.
In that case you can invoke esxtop in batch mode, something like this should do

"esxtop -b /<folderpath>/esxtopdata.csv"

You can then import this into an excel workbork and manipulate it for the required graphs, charts etc etc.
but just a word of caution, depending the data collection interval, the log file can be huge.

You can also use the esxplot tool developed by Geoff White as GUI for all the data tha you collect

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
securitythreatAuthor Commented:
Data is not complete but partial answer.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.