Report performance

[Techinal_Suppor]

Hi, I am taking performance report of my VMs using VI cliet ( Right click VM then report performance) but it takes only oneday report...if i take 1 week or 1 month report it only generate 0KB excel file..and if i open the file..it gives the error "unable to read the file"..i am not sure wheather it is storing only one day report...do u know is there any setting so that i will edit it and store the report for a week...i have checked the setting in setting statistics under VC server management server configuration under adminstration where all field are checked...Plz advise..

[Dave_Mishchenko]

Your post has been moved to the VI: vCenter Server forum.

Dave Mishchenko

VMware Communities User Moderator

[aldikan]

Hi,

I can see reports going quite far back..

Please proved more info on the VI version and your setup,

Are you using SQL express, SQL 2000 or 2005,

Also please check if you can get reports when using another PC with the VI client installed?

Alex

[Techinal_Suppor]

Hi, Thanks for yr help..First i am using SQL 2005 ..and i have tried the same from other system where VI client is installed..but no luck the sam error...Do you is there any setting in VC server..so that i could collect this report for a week..

[Erik_Zandboer]

Hi, are you able to see graphs older than 1 day? Normally, what you see is what you get from the XLS export feature. If data is not stored properly in the SQL database, you might want to check out the settings (from the VI client): Administration tab (NOT button)....VirtualCenter management server configuration... and then the item "statistics". Make sure the data is kept for the appropriate level and time there....

[Techinal_Suppor]

Hi..I am able to see the report and graph only 1 day older...not more than one day...i have checked VC management server configuraion under administration tab..all field checked ..like 5 min for 1 day, 30 min for week , 2 hr for month and 1 day for a year..all mark are cheked ..plz advised...

[obriensl]

I am also seeing this issue. Using Vcenteer 2.5/ESX 3.5 and SQL 2005, I can only get performance graphs for 1 day, even though all statistics settings are checked. Anything other than 1 day says performance data not available. Has anyone figured out what may be causing this?

[heybuzzz]

esx 3.5 update 2 - VC 2.5 update 2...also see 0 data past 1 day.

[Techinal_Suppor]

Thank you for yr help...Is there any way so that i could collect data for 1 week or month..because it is giving data only for 1 day...earlier when i was using esx 3.0.1 we were able to collect the data for month as well..............Thanks

[Techinal_Suppor]

Do you have any solution for this...

[Techinal_Suppor]

Hi..Is there any alternative for this..so that i could fetch the report..

[Erik_Zandboer]

Depending on what you want to see, you should select the appropriate statistiscs level. VirtualCenter does not keep all data beyond a single day... If you want to see more, you should change the statistics level. Check out the second part of one of my blogs. There is a description how you can get (for example) CPU ready times for an enrtire week:

[Techinal_Suppor]

Hi..thnaks... i have changed the statistics level accoding to your document , after that also if look CPUand memory performance chart for a week , it says performance data in not available for this entity...

[Techinal_Suppor]

I dont think this is possible to take performace data for more than 1 day..

[Erik_Zandboer · Accepted solution]

Hi,

Just to make 100% sure: You look at performance graphs, click on "change chart options", you select CPU / past day, and you see performance data in a graph. Then you go back to "change chart options", and select past week instead of past day, follwoed by "ok", and then it displays "data is not available" ?

If so, try to set the same settings again (so click "change chart options" once more, and select OK). This is because I have seen buggy behaviour sometimes after the first time you make a selection.

It could also be a matter of time; performance data has to "fill up" the database before it can display (although I would expect it only draw the last day of a weekly graph). You should see something like in the snap attached to this post (I did erase the hostname out of this snap)

Visit my blog at http://erikzandboer.wordpress.com

[Techinal_Suppor]

Thank you very much for your help.even i changed the the chart option for some VM it works fine...for some VM it gives again the message data is not available. It gives only last one day details out of the week., is there any way where we change in database and it will store by default weekly or monthly report...If you have any idea about database plz let me know..thannks again..

[Erik_Zandboer]

Weird stuff.

Are you sure these VMs do have a history of existence within your environment? If data has been gathered for over a week, I would surely expect that data to be stored into VC's database. Have you ever seen "hickups" like performance graphs having "blind spots" carrying no data? I have seen these issues sometimes, and has to do with VC not being able to send off its data fast enough to the database. Also, the realtime data from the ESX hosts is sent using UDP, so bad connections / packet loss might also be responsible.

I am not sure how big your envirnment is, but I would consider to reinstall VC server and start over with a fresh database, prferably not with firewalls between the path from ESX service console to virtual center to VC-database server (or just combine VC and the database on one single host).

Visit my blog at http://erikzandboer.wordpress.com

[obriensl]

We have had our environment up for over 6 months, and I still can only see performance charts for 1 day. I checked all the settings, they look fine.

I went into Performance, Change Chart options, select CPU, Past week - get data currently not available, no matter how many times I try it.

There has to be something I'm missing?

[msemon1]

Take a look at the database and tables since they could have grown quite large and become corrupted. You might look at the following cleanup script

VCDB_table_cleanup_MSSQL.sql. The problem table usaully I think is usually VPX_HIST_STAT1. Ours had grown to about 17GB? We had to reinitialize

the database.

Mike

[rreynol]

This URL may be of help:

http://theether.net/kb/100060