Solved

vmware performance data missing

Posted on 2013-06-13
17
352 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 121
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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 121
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: 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

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as the high-speed power of the cloud.

Question has a verified solution.

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

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
A look into Log Analysis and Effective Critical Alerting.
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

631 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