Real-time performance monitoring and troubleshooting
Post Reply
wenxin1234114
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

which table is cpu usage stored ?

Post by 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 :D
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: which table is cpu usage stored ?

Post by 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
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

Re: which table is cpu usage stored ?

Post by wenxin1234114 »

Vitaliy S. wrote: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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: which table is cpu usage stored ?

Post by Vitaliy S. »

Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt
wenxin1234114
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

Re: which table is cpu usage stored ?

Post by wenxin1234114 »

Vitaliy S. wrote: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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: which table is cpu usage stored ?

Post by 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
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

Re: which table is cpu usage stored ?

Post by wenxin1234114 »

Vitaliy S. wrote: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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: which table is cpu usage stored ?

Post by veremin » 1 person likes this post

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
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

Re: which table is cpu usage stored ?

Post by wenxin1234114 »

v.Eremin wrote: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
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: which table is cpu usage stored ?

Post by veremin »

Can I extract real-time performance from cache with version 6 ?
Unfortunately, it’s not possible. Thanks.
wenxin1234114
Novice
Posts: 6
Liked: never
Joined: Jul 01, 2013 1:31 am
Full Name: wenxin1234114
Contact:

Re: which table is cpu usage stored ?

Post by wenxin1234114 »

v.Eremin wrote: Unfortunately, it’s not possible. Thanks.
Anyway ,I appreciate you .
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: which table is cpu usage stored ?

Post by veremin »

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

Who is online

Users browsing this forum: No registered users and 9 guests