Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

vmware performance data missing

Posted on 2013-06-13
17
Medium Priority
?
353 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 123
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
Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

 
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 123
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

When ransomware hits your clients, what do you do?

MSPs: Endpoint security isn’t enough to prevent ransomware.
As the impact and severity of crypto ransomware attacks has grown, Webroot has fought back, not just by building a next-gen endpoint solution capable of preventing ransomware attacks but also by being a thought leader.

Question has a verified solution.

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

In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
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.
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

688 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