Solved

vmware performance data missing

Posted on 2013-06-13
17
351 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 15
  • 2
17 Comments
 
LVL 120
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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 120
ID: 39253607
Is you SQL Agent running on SQL Server?
0
 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
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 video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

751 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