Solved

vmware performance data missing

Posted on 2013-06-13
17
347 Views
Last Modified: 2013-06-22
We have 4 servers (esxi) in a cluster, 2 of them have no performance data other than real time.

Yesterday we did a

services.sh restart command and all looks fine, but this did not fix my issues.
I have looked at this
http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1003490
and
http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1005566
and
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1003878

other than rebooting the host itself, what other options do I have?

Currently running 4.1 patched up as far as it can go before 5.x

The services.sh restart was issued late in the day, 2pm roughly, so it has not been 24 hours yet. I dont know if that matters or not, but I expected to see some data in the 1 day option already. Perhaps we have to wait another day?
0
Comment
Question by:wlacroix
  • 15
  • 2
17 Comments
 
LVL 118
ID: 39244727
Are the rollup jobs running on SQL?
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39244859
Yes were running vcenter and a full blown SQL server.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39244878
I have restarted the SQL server that this stuff is sitting on, will have to wait and see now. There is an event error 140 regarding report service.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39245228
So I have some data but not all data.

host1 no data but real time
host2 no data but real time
host4 all ok, yearly data as well
host5 no data but real time

SQL server has been restarted, and the jobs are running fine, they show success and no errors in event viewer. This holds true because host4 has all its data.

We dug around and on april 27th we had a huge issue that hammered this cluster, so there is something stuck inside 1,2,5 that is affecting it.

Does anyone know exactly what services deal with performance data? I will kill each one specifically, using this article:

http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1005566
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39245231
Either the data is not getting to SQL, or its not being retrieved by SQL.
Either way its the hosts themselves not SQL that is the issue.
So far.....
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39247766
Still no luck with this.

Does anyone know the exact services that run the performance data stuff?

I am going to reboot a host right now and see what happens over the weekend.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39253425
Even after a full reboot of the host, there is no performance data other than real time.
0
 
LVL 118
ID: 39253607
Is you SQL Agent running on SQL Server?
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 3

Author Comment

by:wlacroix
ID: 39253720
Yes it sure is, one of the hosts has data

Vmhost1 no
Vmhost2 no
Vmhost4 yes
Vmhost4 no

So I know the SQL server and agent are working properly (at least in theory), but for whatever reason the hosts dont have performance data but real time.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39253729
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39253755
My SQL guy is going over that document now, we will see what he comes up with.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39253855
As far as we can see, there is nothing wrong on the SQL server itself.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39254263
Upgrade of vmtools to my vcenter server, windows updates and some cleanup, just to make sure its not that box, also allocated more memory.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39254297
The only other thing I have not done is reboot vmhost1, it runs all that is critical in my world and I am afraid.
0
 
LVL 3

Accepted Solution

by:
wlacroix earned 0 total points
ID: 39254648
Reboot of the vCenter server has fixed this issue. For whatever reason......
But I dont know if all the other stuff I had done had any impact on the result.

thanks for the help.
0
 
LVL 3

Author Comment

by:wlacroix
ID: 39254651
Restart management
Restart SQL
Restart vCenter server

If you come across the thread, try this, in this order and see if it helps.
0
 
LVL 3

Author Closing Comment

by:wlacroix
ID: 39267790
I basically solved this myself, but dont know if what I had done previous to the vcenter restart was necessary.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now