which table is cpu usage stored ?

Real-time performance monitoring and troubleshooting

which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Mon Jul 01, 2013 1:40 am

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

Re: which table is cpu usage stored ?

Veeam Logoby Vitaliy S. » Mon Jul 01, 2013 8:41 am

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!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Mon Jul 01, 2013 9:55 am

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

Re: which table is cpu usage stored ?

Veeam Logoby Vitaliy S. » Mon Jul 01, 2013 1:13 pm

Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Mon Jul 01, 2013 2:28 pm

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

Re: which table is cpu usage stored ?

Veeam Logoby Vitaliy S. » Mon Jul 01, 2013 3:46 pm

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.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Tue Jul 02, 2013 12:57 am

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

Re: which table is cpu usage stored ?

Veeam Logoby v.Eremin » Tue Jul 02, 2013 9:56 am 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.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Tue Jul 02, 2013 10:11 am

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

Re: which table is cpu usage stored ?

Veeam Logoby v.Eremin » Tue Jul 02, 2013 10:16 am

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

Unfortunately, it’s not possible. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: which table is cpu usage stored ?

Veeam Logoby wenxin1234114 » Tue Jul 02, 2013 11:15 am

v.Eremin wrote:
Can I extract real-time performance from cache with version 6 ?

Unfortunately, it’s not possible. Thanks.

Anyway ,I appreciate you .
wenxin1234114
Novice
 
Posts: 6
Liked: never
Joined: Mon Jul 01, 2013 1:31 am
Full Name: wenxin1234114

Re: which table is cpu usage stored ?

Veeam Logoby v.Eremin » Tue Jul 02, 2013 11:36 am

You’re welcome. Feel free to contact us, should any additional help be needed. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests