Virtual Machines Keeping only 1 Day of performance Stats since ESX Upgrade.

[Nicholas_Duquet]

Hello,

Since upgrading from ESX 3.0.2 to 3.5.0 Build 70356 with VIC 2.5 build 64192 I have noticed that my performance data on my virtual machines only hold 24hours of data. It appears to be truncating the data some how. I would like to keep historical data. I have no data from past week, past month, but when I select past year I can see my data all the way to the date of the upgrade. Then nothing.

Wondering what configuration change has happend.

I have rebooted ESX servers and VMs. I have droped both ESX servers one at a time out of our data center cluster and re added.

Any help would be appreciated!

Thanks,

Nick

[juchestyle]

Has it only been one day of info for several days, or you just notice it today?

Is this all your vms or just a few?

R,

Matthew

Kaizen!

[Nicholas_Duquet]

All VMs including performance statistics on the ESX servers themselves.

This was just recently noticed. I can view performance data in real time and for the last 24hours only. However if I choose a custom report of 25 hours. I get "Performance Data is currently not available for this entity" for a message.

[Nicholas_Duquet]

Anyone else have any thoughts on this? I still cant seem to figure out what is going on..

[MZ11]

You should look at your SQL-Server. I had this problem too. Reason was a full transaction-log. A periodic truncate job may solve your issue.

MZ1

[Patrick_Miller]

Nick,

During the upgrade process, did you go from MSDE to SQL Express? If so, you might want to check out this thread .

[Nicholas_Duquet]

Hello,

Thank you for your reply. I finnally got into look at the SQL DB. Turns out that the 1.5G DB had a 21G log file. I ran the following to backup and shrink the logfile.

BACKUP LOG VMWare WITH TRUNCATE_ONLY

DBCC SHRINKFILE (’VMWare_Log‘,1)

BACKUP LOG VMWare WITH NO_LOG

The log file shrunk fine and the backup had no errors. After an hour I ran a custom chart on a VM to view performance data and there is no change. I can still see just 1 days worth. Not the past 25 hours. I did a view past year to make sure the historical data from months ago is still there before it stopped logging and it is.

Any other thoughts? Maybe I am missing a step?

Thanks,

Nick

[juchestyle]

Hey man,

We have the same issue, and I found a thread that says if you are running vc 2.5 with sql express, you are out of luck. Apparently the monopoly, oops, sorry, micro$oft has removed the agent that compiles daily stats into weekly, monthly, and yearly. This from what I am aware is a known issue.

http://communities.vmware.com/thread/119906

Respectfully,

Matthew

Kaizen!

[Nicholas_Duquet]

I should have mentioned that I am running SQL2000, not express.

Thank you for the reply though!

[juchestyle]

Laughing, well, that makes you smarter than us!

Respectfully,

Matthew

Kaizen!

[Nicholas_Duquet]

Apologies, I don't follow.. why would that make me smarter?

Thanks,

Nick

[juchestyle]

...because my shop is using express. Soon to change.

R,

Matthew

Kaizen!

[craigal · Accepted solution]

Hi,

We had the same issue after we upgraded VC to 2.5

The jobs that perform the rollup of the performance data are SQL batch jobs.

In our case the SQL Agent Service was not started and thus these jobs were not running.

Cheers

Craig

[Nicholas_Duquet]

Looks like that was it. My SQL Agent wasnt running due to the following error.

SQL Server agent unable to locate entry point for AXSCPHST.DLL

I corrected this by modifying the following reg key on the server.

the entry was..

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL

Server\80\Tools\ClientSetup

"SQLPath"="C:
Program Files
Microsoft SQL Server
80
Too"

I changed it to

"SQLPath"="C:
Program Files
Microsoft SQL Server
80
Tools"

Restarted the SQL Agent and it started.

Now I am running the rollup jobs manually for now since I have so much data that hasnt been rolled up it took 2 hours to do the Day Stats.

Looking Good now!

Thanks all!!!

Nick