Nodata in the [DiskRead and Write]&[Network Received and Transmitted] of the reports

[JackKuo]

Hello everyone!

I'm a newbie.

The problem is the column of [DiskRead and Write]&[Network Received and Transmitted] has nodata.The others are OK(CPU,Memory etc.).  I already set the base rate for [DiskRead and Write]&[Network Received and Transmitted]  and I do some operations like copy files from one to another VM in the VM. But it still 0.00 in the report .

Can anybody tell me why? Is anything wrong in my vCenter Database?

Thank you very much!

[JackKuo]

The VMs are in the cluster and the storage is NFS.

[Mugdha]

Hello,

There could be multiple reasons why this might be happening. We need to know a few things before we could find out the reason.

1) Please tell us the details of the pricing model you are using.

2) Please paste the output of running following query. Please note that you need to replace the name of the vm with the actual one

select sample_time, sample_interval, resource_id, value from cb_vc_performance_stat where resource_id in (2,6) and vc_entity_moid=(select entity_moid from cb_vc_entity where vc_entity_id=(select vc_entity_id from cb_vc_entity_mapping where cb_entity_id=(select entity_id from cb_entity where entity_name='name of the vm'))) order by resource_id

3) It will also be helpful if you can attach the pdf report.

[JackKuo]

Hello!

Thanks for reply. All you need is in the attachment.

The VM(work_GJL) is in the resource pool which is named O3W.And the resouce pool is in a cluster,the storage is NFS.

[Mugdha]

Hello,

Thanks for sending the data.

The query that we asked you to run gives the values of network transmit-receive and disk read-write that CBM data collector has collected from VC.

A closer look at the output of the query shows that CBM has been able to collect data for network received and transmit (resource_id=6) from VC. The attached report contains costs for network received and transmit.

But there is no data for disk read and write (resource_id=2). So the report shows 0 costs for disk read and write.

Now we need to know the cause of  absence of this data from CBM DB. As a first step, we will like to see if VC DB contains disk read-write related data. Can you please attach the output of following steps?

1)  Please run following query on CBM DB

select entity_moid from cb_vc_entity where vc_entity_id=(select vc_entity_id from cb_vc_entity_mapping where cb_entity_id=(select entity_id from cb_entity where entity_name='work_GJL'))

This will give 'moid'. This moid should be used in the next query.

2) Please run following queries on VC DB.

We need outputs from 4 tables namely:

i) VPXV_HIST_STAT_YEARLY

ii) VPXV_HIST_STAT_MONTHLY

iii) VPXV_HIST_STAT_WEEKLY

iv) VPXV_HIST_STAT_DAILY

Substitute <table name> in the following query with each one of these and store the outputs of different queries independently and attach here.

select SAMPLE_TIME, SAMPLE_INTERVAL, STAT_VALUE from <table name> where ENTITY LIKE 'moid from above query' AND STAT_NAME = 'usage' and STAT_GROUP = 'disk' and STAT_ROLLUP_TYPE = 'average' order by SAMPLE_TIME

Thanks,

Mugdha

[JackKuo]

Hello,

Thanks for reply.

I got the moid by the above query on CBM DB. And I ran the 4 queries on VC DB but there is no output.(The queries executed successfully,the result is null.)So is there anything wrong in my VC DB? Can this problem be fixed?

*The VC DB is SQL Server 2008 R2.

I have there resource pools in the cluster,and all of VMs in the pools have the same problem.The VMs which is not in the resource pool have the data of disk read-write.

Thanks again.

[Mugdha]

Hello,

The absence of data shows that VC there are no stats about disk read and write in VC DB. I will direct this to an expert from VC team.

Regards,

Mugdha

[Mugdha]

Hello,

I am just forwarding the reply that I got from VC team:

==========================================================

I would suggest we first verify if we are seeing any other metric counters (e.g CPU usage) being collected successfully into the VC DB  by looking at the past day performance chart under the Advanced->Performance in VI client and take a look at the host where this VM is residing on. If there are stats available, then that means VC has successfully collected stats from this ESX host. And the query result is only indicating the specific disk related metric counters is not available. 

Is the past data data not available across multiple ESX hosts or only on certain specific ESX host? Based on the outcome, we can then determine what else we should collect to further troubleshoot this issue.

==========================================================

[JackKuo]

Hello,

Thank you for reply.

I confirmed the performance chart at the host where the VM(work_GJL) is residing on.There are stats available.

I did some test,the issue has occured when the VM is on a NFS.If I migrate the VM to the local disk of the ESXi host then the [Disk Read and Write] is available.

My ESXi version is 5.1.0 Build 838463,vCenter Server version is 5.1.0 Build 880146.

Thanks.