ESXi 5.1 View Percentage of Reads / Writes on the Datastore

Do the performance charts have the ability to list the percentage of reads and writes per datastore?

I noted all of my performance charts of any of my 100+ datastores are listed as No Data Available and believe this relies on a SQL job to pull the information correct?
LVL 21
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Averages and Summations of datastores metrics are generally what is available in realtime.

For data recorded, highest latency and average usage is recorded in the summaries.
compdigit44Author Commented:
Keep getting No Data Available... When I click the Performance tab of the datastore
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
what exact actions are you performing here....
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

compdigit44Author Commented:
1) Open VIClient to connect to vCenter
2) Change to the Datastore View
3) Select a datastore and click the performance tab
4) from the drop down menu change it to performance... and nothing
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
we have real time statistics...and when we click day, week, month...

Data is not collected for the current statistics level. Increase the statistics level to view the graphs.
compdigit44Author Commented:
Stats for Intervals 5 minutes - 1 day are already enabled with a stats level of 1
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
something not correct with your Db.
compdigit44Author Commented:
I know were are running 5.1 GA and planning to upgrade to 6.0 very soon hopefully this will fix it. Also performance charts on host and Vm works just fine and seems to only be an issue if you view the performance chart on a datastore

ANything I can do in the mean time
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Sometimes, reports can timeout, we've have seen this on under resourced SQL servers.

The data will be resident in the SQL tables, if you have the skills to extract the data.

but back to the original question, they will only show the data for the datastores, by design, and not by your specific % read and % write requirements.

The lack of data being returned highlights another issues.
compdigit44Author Commented:
Thank you for your insight as always.. I know I have problems with vcenter and it needs some TLC and hope things will improve a bit with housekeeping and upgrade to 6.0 update 1 when it is out.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Think carefully about your design, with vCenter Server 6.0 and standalone Plarform Service Controller, or installed with vCenter Server.

and also whether you want to create new install or update the existing database. (and carry the issues!)

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
compdigit44Author Commented:
Unfortunately with 110 host and ~800 VM I have not choice to upgrade... :-(
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.