-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
which table is cpu usage stored ?
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
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
-
- 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 ?
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!
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!
-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
Re: which table is cpu usage stored ?
I see cpu usage ,memory usage and disk usage in Dash board ,I want to extract the performance data integrated with other app .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 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 .
-
- 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 ?
Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt
-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
Re: which table is cpu usage stored ?
Dear Vitaliy,Vitaliy S. wrote:Our devs say that real-time data can be found in this table, please check it out: monitor.PerfSampleRt
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 ?
-
- 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 ?
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.
Also please click Help->About in Monitor Client to make sure you have 5.0.0.261 build installed.
-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
Re: which table is cpu usage stored ?
I tried on Monitor 5.0.0.261 and 6.5.0.676 ,both no data .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.
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.
-
- 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 ?
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.
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.
-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
Re: which table is cpu usage stored ?
Sorry ,I made a mistake .I could not see performance data in dash board with 5 version .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.
Can I extract real-time performance from cache with version 6 ?
-
- 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 ?
Unfortunately, it’s not possible. Thanks.Can I extract real-time performance from cache with version 6 ?
-
- Novice
- Posts: 6
- Liked: never
- Joined: Jul 01, 2013 1:31 am
- Full Name: wenxin1234114
- Contact:
Re: which table is cpu usage stored ?
Anyway ,I appreciate you .v.Eremin wrote: Unfortunately, it’s not possible. Thanks.
-
- 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 ?
You’re welcome. Feel free to contact us, should any additional help be needed. Thanks.
Who is online
Users browsing this forum: No registered users and 9 guests