Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

vmware performance data missing

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
wlacroix
Asked:
wlacroix
  • 15
  • 2
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Are the rollup jobs running on SQL?
0
 
wlacroixAuthor Commented:
Yes were running vcenter and a full blown SQL server.
0
 
wlacroixAuthor Commented:
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
Even after a full reboot of the host, there is no performance data other than real time.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Is you SQL Agent running on SQL Server?
0
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
My SQL guy is going over that document now, we will see what he comes up with.
0
 
wlacroixAuthor Commented:
As far as we can see, there is nothing wrong on the SQL server itself.
0
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
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
 
wlacroixAuthor Commented:
Restart management
Restart SQL
Restart vCenter server

If you come across the thread, try this, in this order and see if it helps.
0
 
wlacroixAuthor Commented:
I basically solved this myself, but dont know if what I had done previous to the vcenter restart was necessary.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 15
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now