Hoping to spark off some friendly discussion with this more than anything.
You're able to monitor one performance metric on a database. Only one. Nothing else. Which metric do you choose and why?
Did you learn nothing from LOTR?
One does not simply monitor a single metric.
Oh, yes you can! I did for years.
Is it running ?
:)
If you're going to be like that then the better metric would be "are the users happy?"
nope. because users are never happy ;) that's a single-state metric ...
Ok so it's a stupid question. I get that. Let me fix it a little.
Top 10 metrics? Is that more reasonable?! ;)
I would like to see how much data is being read from DB but never used. Or in other words how much is bad queries costing me. (Is that considered just one metric ??)
Abri, that's going to be really hard to monitor from a server side perspective, although it would be possible with -zqilv switched on on the clients and then looking at the DB logs. BUT (and it's a very big but), it will grow you DB log files at an unmanageable rate so it's not practical. There's stuff about this sort of thing from a developer's perspective here: www.jdpalmer.co.uk/index.php
Yes [mention:b95db7be848d40f8a39db30310edfa01:e9ed411860ed4f2ba0265705b8793d05] that's heading in the right sort of direction I guess. :)
The thinly veiled purpose behind my question is to gain inspiration for what I could/should be monitoring in order to take a more proactive approach to monitoring.
user satisfaction.
everything else is a proxy for that.
> On Nov 13, 2015, at 7:33 AM, James Palmer wrote:
>
> Update from Progress Community [https://community.progress.com/]
>
> James Palmer [https://community.progress.com/members/jdpjamesp]
>
> Hoping to spark off some friendly discussion with this more than anything.
>
> You're able to monitor one metric on a database. Only one. Nothing else. Which metric do you choose and why?
>
> View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21385]
>
> You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21385/mute].
>
> Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21385?AbuseContentId=0d2fecd2-b8a2-489b-8743-143fee50db61&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true] this post as spam/abuse.
How would you measure that @gus
You talk to some of them
> On Nov 13, 2015, at 9:20 AM, James Palmer wrote:
>
> Update from Progress Community [https://community.progress.com/]
>
> James Palmer [https://community.progress.com/members/jdpjamesp]
>
> How would you measure that @gus
>
> View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/21385/75144#75144]
>
> You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21385/mute].
>
> Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/21385/75144?AbuseContentId=125986a7-f455-48ef-8345-b1782b42a12b&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true] this post as spam/abuse.