which table is cpu usage stored ?

[wenxin1234114]

Hi ,

I use veeam veeam_monitor_5.0.0.261 ,but I couldn't find where cpu usage and memory usage are stored in table .Could anyone know that ?Thanks

[Vitaliy S.]

Hello,

Performance metrics are stored in different tables based on the aggregation interval. Can you please give me a bit more information on what you want to achieve?

Thanks!

[wenxin1234114]

Hello,

Performance metrics are stored in different tables based on the aggregation interval. Can you please give me a bit more information on what you want to achieve?

Thanks!

I see cpu usage ,memory usage and disk usage in Dash board ,I want to extract the performance data integrated with other app .
I have reviewed all tables and view tables ,Only I found the performance data with interval 300s ,no real time data .As we know ,vcenter /esxi host aggregated the performance data per 20s ,where can I get this data ? Or where can I find the real time data ?Thanks .

[Vitaliy S.]

Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt

[wenxin1234114]

Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt

Dear Vitaliy,

I checked the monitor.PerfSampleRt ,it's empty .But I can see the data in dashboard ,I don't know why .

My host is esxi not vcenter ,is that reason ?

[Vitaliy S.]

Can you please run this script against Veeam Monitor database - select count(*) from PerfSampleRt?

Also please click Help->About in Monitor Client to make sure you have 5.0.0.261 build installed.

[wenxin1234114]

Can you please run this script against Veeam Monitor database - select count(*) from PerfSampleRt?

Also please click Help->About in Monitor Client to make sure you have 5.0.0.261 build installed.

I tried on Monitor 5.0.0.261 and 6.5.0.676 ,both no data .

On Monitor 6.5.0.767 installed in windows 7 32bit sp1 ,script sql :

Code: Select all

select count(*) from veeamone.monitor.PerfSampleRt 

On Monitor 5.0.0.261 installed in windows 2003 64bit sp2 ,script sql :

Code: Select all

select count(*) from veeamone.monitor.PerfSampleRt

Both I can not get data ,but I can get data in PerfSampleMed and PerfSampleLow.

[veremin]

There is no wonder why you didn’t get any data in case of 6.5, since in current version VeeamOne stores real-time performance data in cache rather than in table.

However, the situation with 5 version is strange, indeed. You’ve said that you see required performance data on “Summary” dashboard. So, I'm wondering whether anything is also shown in real time inlays (like, “Memory” , “CPU”, etc.). Can you confirm it?

Thanks.

[wenxin1234114]

There is no wonder why you didn’t get any data in case of 6.5, since in current version VeeamOne stores real-time performance data in cache rather than in table.

However, the situation with 5 version is strange, indeed. You’ve said that you see required performance data on “Summary” dashboard. So, I'm wondering whether anything is also shown in real time inlays (like, “Memory” , “CPU”, etc.). Can you confirm it?

Thanks.

Sorry ,I made a mistake .I could not see performance data in dash board with 5 version .

Can I extract real-time performance from cache with version 6 ?

[veremin]

Can I extract real-time performance from cache with version 6 ?

Unfortunately, it’s not possible. Thanks.

[wenxin1234114]

Unfortunately, it’s not possible. Thanks.

Anyway ,I appreciate you .

[veremin]

You’re welcome. Feel free to contact us, should any additional help be needed. Thanks.